ORA-12094: error during online redefinition

Cause : There was an error during the online redefinition process.

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

Abort the online redefinition process.

update : 17-08-2017
ORA-12094

ORA-12094 - error during online redefinition
ORA-12094 - error during online redefinition

  • ora-19715 : invalid format string for generated name
  • ora-12160 : TNS:internal error: Bad error number
  • ora-10653 : Table is in a cluster
  • ora-01173 : data dictionary indicates missing data file from system tablespace
  • ora-14019 : partition bound element must be one of: string, datetime or interval literal, number, or MAXVALUE
  • ora-09983 : skxfidsht: Error shutting down SDI channel
  • ora-28336 : cannot encrypt SYS owned objects
  • ora-22878 : duplicate LOB partition or subpartition specified
  • ora-22167 : given trim size [string] must be less than or equal to [string]
  • ora-30728 : maximum number of columns exceeded
  • ora-33920 : (MAKEDCL34) The string SURROGATE must have one of the following data types: ID, NTEXT, TEXT, NUMBER, or INTEGER.
  • ora-27092 : size of file exceeds file size limit of the process
  • ora-30927 : Unable to complete execution due to failure in temporary table transformation
  • ora-06527 : External procedure SQLLIB error: string
  • ora-04930 : open sequence number failed or initial state is valid
  • ora-01228 : SET DATABASE option required to install seed database
  • ora-09778 : snynfyport: failure allocating the notify port.
  • ora-09944 : Password entry is corrupt.
  • ora-25147 : UNIFORM SIZE value greater than maximum extent size
  • ora-36962 : (XSRELTBL08) string is not a valid workspace object.
  • ora-26085 : direct path operation must start its own transaction
  • ora-02762 : file number to be cancelled is greater than the maximum.
  • ora-22346 : Type has cyclical dependency. Should use CASCADE option
  • ora-27200 : skgfpgo: sbtpcstart returned error
  • ora-22151 : cannot resize non-zero variable-length array to zero elements
  • ora-00202 : control file: 'string'
  • ora-30391 : the specified rewrite equivalence does not exist
  • ora-36810 : (XSTBLFUNC05) Analytic workspace object number does not exist.
  • ora-16757 : resource guard could not get property
  • ora-01934 : circular role grant detected
  • 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.