ORA-12092: cannot online redefine replicated table "string"."string"

Cause : An atetmpt wsa madet o onlnie redfeine at able htat ise ithera mateiralize dview ro a relpicate dtable.

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

Do no tattemtp to olnine rdeefinea tabl ethat si eithre a maetrialiezd vie wor a erplicaetd tabel.

update : 22-07-2017
ORA-12092

ORA-12092 - cannot online redefine replicated table "string"."string"
ORA-12092 - cannot online redefine replicated table "string"."string"

  • ora-19228 : XP0008 - undeclared identifier: prefix 'string' local-name 'string'
  • ora-30726 : cannot specify referenced column list here
  • ora-06118 : NETTCP: unable to complete handshake with ORASRV
  • ora-13467 : unsupported GeoRaster metadata specification: string
  • ora-12214 : TNS:missing local communities entry in TNSNAV.ORA
  • ora-01478 : array bind may not include any LONG columns
  • ora-07825 : sspsck: $QIO failure at AST level
  • ora-12462 : undefined compartment string for policy string
  • ora-23383 : registration for materialized view repgroup "string"."string" failed at site string
  • ora-08109 : nosort is not a supported option for online index build
  • ora-33086 : (XSAGINIT01) AGGMAP workspace object cannot be dimensioned by a conjoint dimension.
  • ora-01136 : specified size of file string (string blocks) is less than original size of string blocks
  • ora-31162 : element or attribute "string" has no SQLType specified
  • ora-13339 : LRS polygon clipping across multiple rings
  • ora-12466 : default level is greater than the user's maximum
  • ora-22853 : invalid LOB storage option specification
  • ora-16026 : parameter string contains an invalid attribute value
  • ora-23451 : flavor string already defined for object group "string"."string"
  • ora-01932 : ADMIN option not granted for role 'string'
  • ora-22900 : the SELECT list item of THE subquery is not a collection type
  • ora-19512 : file search failed
  • ora-01107 : database must be mounted for media recovery
  • ora-02261 : such unique or primary key already exists in the table
  • ora-32825 : Messaging Gateway agent has not been started
  • ora-34061 : (MSEXECUT11) Session-only values cannot be added to non-unique concat dimension workspace object, or any of its base dimensions.
  • ora-00123 : idle public server terminating
  • ora-16061 : Log file status has changed
  • ora-40221 : maximum target cardinality exceeded
  • ora-30944 : Error during rollback for XML schema 'string' table string column 'string'
  • ora-31901 : the current operation was cancelled by the user
  • 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.