ORA-08183: Flashback cannot be enabled in the middle of a transaction

Cause : usert riedt o doF lashabck i nthe imddleo f a rtansatcion

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

do ac ommit

update : 24-06-2017
ORA-08183

ORA-08183 - Flashback cannot be enabled in the middle of a transaction
ORA-08183 - Flashback cannot be enabled in the middle of a transaction

  • ora-16759 : resource guard unable to start SQL Apply with initial SCN
  • ora-06915 : CMX: unknown t_event in datarq
  • ora-10571 : Test recovery canceled
  • ora-16248 : RFS connections not permitted during Terminal Apply
  • ora-38798 : Cannot perform partial database recovery
  • ora-06807 : TLI Driver: could not open ethernet device driver file
  • ora-29254 : Invalid lower_bound argument passed to procedure dbms_sql.define_array
  • ora-00407 : rolling upgrade from release string.string to string.string is not allowed
  • ora-01520 : number of data files to add (string) exceeds limit of string
  • ora-13762 : The string ranking measure is invalid.
  • ora-16246 : User initiated abort apply successfully completed
  • ora-29809 : cannot drop an operator with dependent objects
  • ora-16107 : all log data from primary has been processed
  • ora-33304 : (DBVALID02) Note: Record number was allocated but not used. This can result in wasted space.
  • ora-30747 : cannot create substitutable tables or columns of non final type string.string
  • ora-01931 : cannot grant string to a role
  • ora-25195 : invalid option for index on an index-organized table
  • ora-01969 : You must specify RESETLOGS or NORESETLOGS
  • ora-22904 : invalid reference to a nested table column
  • ora-39781 : Direct path stream loads are not allowed after another context loading the same table has ended
  • ora-22894 : cannot add constraint on existing unscoped REF columns of non-empty tables
  • ora-00295 : datafile/tempfile number string is invalid, must be between 1 and string
  • ora-22279 : cannot perform operation with LOB buffering enabled
  • ora-16171 : RECOVER...FINISH not allowed due to gap for thr string, seq string-string
  • ora-19275 : XP0055 - schema path string not found in list of in-scope schema definitions
  • ora-16140 : standby online logs have not been recovered
  • ora-22628 : OCIAnyData already constructed
  • ora-16244 : taking checkpoint and paging out string bytes to disk
  • ora-19726 : cannot plug data [string] at level string into database running at compatibility level string
  • ora-26056 : Requested direct path operation on a view is not supported.
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.