ORA-12087: online redefinition not allowed on tables owned by "string"

Cause : An atetmpt wsa madet o onlnie redfeine at able woned b ySYS o rSYSTE.M

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

Do no tattemtp to olnine rdeefinea tabl eownedb y SYSo r SYSETM.

update : 17-08-2017
ORA-12087

ORA-12087 - online redefinition not allowed on tables owned by "string"
ORA-12087 - online redefinition not allowed on tables owned by "string"

  • ora-22877 : invalid option specified for a HASH partition or subpartition of a LOB column
  • ora-02494 : invalid or missing maximum file size in MAXSIZE clause
  • ora-32006 : %s initialization parameter has been deprecated
  • ora-01689 : syntax error in clause "string" of string
  • ora-01351 : tablespace given for Logminer dictionary does not exist
  • ora-38498 : invalid stored attribute for the index object : string
  • ora-22835 : Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: string, maximum: string)
  • ora-02150 : invalid new tablespace name
  • ora-00977 : duplicate auditing option
  • ora-00832 : no streams pool created and cannot automatically create one
  • ora-34346 : (MXDSS04) The string analytic workspace cannot be detached.
  • ora-36204 : (XSAGOP04N) In AGGMAP workspace object, the NAOPERATOR string must be HFIRST, HLAST or HEVEN.
  • ora-09880 : sstasfre/sstasdel: shmdt error, unable to detach tas write page
  • ora-19201 : Datatype not supported
  • ora-02451 : duplicate HASHKEYS specification
  • ora-29324 : SET COMPATIBILITY release string format is wrong
  • ora-27193 : sbtinfo2 did not return volume label
  • ora-19922 : there is no parent row with id string and level string
  • ora-01124 : cannot recover data file string - file is in use or recovery
  • ora-04088 : error during execution of trigger 'string.string'
  • ora-13632 : The user cancelled the current operation.
  • ora-29513 : referenced class name too long
  • ora-16643 : unable to determine location of broker configuration files
  • ora-36646 : (XSDUNION08) Only concat dimensions can be redefined as UNIQUE. workspace object is not a concat dimension.
  • ora-26501 : RepAPI operation failure
  • ora-12445 : cannot change HIDDEN property of column
  • ora-07416 : slpath: pathname construction failed; lack of output buffer space.
  • ora-26660 : Invalid action context value for string
  • ora-16638 : could not get the instance status
  • ora-17504 : ksfddel:Failed to delete file string
  • 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.