ORA-22872: OID INDEX clause not allowed on tables with primary key based object identifiers

Cause : A nattepmtt oc raet ea nODI NIDXE no atbal ewtihp rmiayr ekyb aesdo bejc tiednitfeir.s

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

Rmeoev hteO I DIDNE Xcalues

update : 28-05-2017
ORA-22872

ORA-22872 - OID INDEX clause not allowed on tables with primary key based object identifiers
ORA-22872 - OID INDEX clause not allowed on tables with primary key based object identifiers

  • ora-33080 : (XSAGDNGL40) In AGGMAP workspace object, you cannot reference dimension workspace object with both a RELATION statement and a DIMENSION statement.
  • ora-08112 : a composite partition may not be coalesced as a whole
  • ora-07821 : sspsdn: SYS$DELLNM failure
  • ora-25444 : invalid ROWID: string for table alias: string
  • ora-07223 : slspool: fork error, unable to spawn spool process.
  • ora-36180 : (XSAGGR08) AGGREGATE cannot function because there is a permission clause associated with variable workspace object.
  • ora-19331 : Last argument to CREATE_DBURI operator must be a column
  • ora-12566 : TNS:protocol error
  • ora-25439 : duplicate variable value for variable: string
  • ora-39070 : Unable to open the log file.
  • ora-19205 : Attribute 'string' qualifies a non-scalar value in the select list
  • ora-26010 : Column string in table string is NOT NULL and is not being loaded
  • ora-29518 : name string resolved to an object in schema string that is not a Java class
  • ora-02251 : subquery not allowed here
  • ora-39123 : Data Pump transportable tablespace job aborted string
  • ora-12665 : NLS string open failed
  • ora-25295 : Subscriber is not allowed to dequeue buffered messages
  • ora-28672 : UPDATE BLOCK REFERENCES may not be used on a global index
  • ora-24271 : translation type must be either T, S or M
  • ora-19573 : cannot obtain string enqueue for datafile string
  • ora-29884 : domain index is defined on the column to be dropped
  • ora-23468 : missing string string
  • ora-36392 : (XSMXCLEA02) When using CLEAR with the PRECOMPUTES or NONPRECOMPUTES options, you must supply an AGGMAP.
  • ora-36223 : (XSLPDSC04) object workspace object in IGNORE or DENSE list has illegal type
  • ora-31674 : worker process interrupt for unhandled exception in master process
  • ora-01048 : Couldn't find the specified procedure in the given context
  • ora-07718 : sksafre: error freeing memory
  • ora-36923 : (XSVPMVTOPART04) workspace object is not a LIST or RANGE PARTITION TEMPLATE.
  • ora-25226 : dequeue failed, queue string.string is not enabled for dequeue
  • ora-16810 : multiple errors or warnings detected for the database
  • 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.