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 : 23-09-2017

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-13641 : Task cannot be interrupted yet. You may cancel it instead.
  • ora-38419 : invalid identifier in attribute : string
  • ora-24001 : cannot create QUEUE_TABLE, string already exists
  • ora-12463 : undefined group string for policy string
  • ora-12083 : must use DROP MATERIALIZED VIEW to drop "string"."string"
  • ora-23453 : requested operation is not supported on top flavor
  • ora-13509 : error encountered during updates to a AWR table
  • ora-30431 : refresh method must be ANY or INCREMENTAL or FORCE_FULL, not string
  • ora-12560 : TNS:protocol adapter error
  • ora-21603 : property id [string] is invalid
  • ora-01693 : max # extents (string) reached in lob segment string.string
  • ora-12439 : invalid combination of policy options
  • ora-13407 : invalid storage parameter
  • ora-06524 : Unsupported option : string
  • ora-13020 : coordinate is NULL
  • ora-01624 : log string needed for crash recovery of instance string (thread string)
  • ora-06754 : TLI Driver: unable to get local host address
  • ora-21301 : not initialized in object mode
  • ora-07595 : sppid: $GETJPIW failure
  • ora-09701 : scnfy: maximum number of processes exceeded
  • ora-13221 : unknown geometry type in the geometry object
  • ora-36610 : (XSLMS00) Unable to locate a message file for OLAP message: value
  • ora-01491 : CASCADE option not valid
  • ora-13384 : error in network schema: string
  • ora-24127 : TABLESPACE parameter specified with an ACTION other than CREATE_ACTION
  • ora-06792 : TLI Driver: server cannot exec oracle
  • ora-10979 : trace flags for join index implementation
  • ora-02381 : cannot drop PUBLIC_DEFAULT profile
  • ora-13019 : coordinates out of bounds
  • ora-19503 : cannot obtain information on device, name="string", type="string", parms="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.