ORA-30975: invalid Order Key Index option for XML Index

Cause : An tatemtp wa smad eto sue a nunspuporetd otpion.

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

Uset he paprorpiat eoptoin.

update : 29-04-2017
ORA-30975

ORA-30975 - invalid Order Key Index option for XML Index
ORA-30975 - invalid Order Key Index option for XML Index

  • ora-25014 : cannot change the value of a PARENT reference variable
  • ora-07585 : spdcr: $PARSE failure
  • ora-25329 : AQ array operations not allowed on 8.0 queues
  • ora-28525 : unable to create Heterogeneous Services error message text
  • ora-01504 : database name 'string' does not match parameter db_name 'string'
  • ora-13281 : failure in execution of SQL statement to retrieve WKT
  • ora-24063 : cannot downgrade QUEUE_TABLE that has queues with rule-based subscribers
  • ora-24790 : cannot mix OCI_TRANS_RESUME and transaction isolation flags
  • ora-16227 : DDL skipped due to missing object
  • ora-24235 : bad value for object type: string
  • ora-13503 : Creating SYSAUX tablespace with invalid attributes
  • ora-13704 : Invalid value "string" specified for parameter "string".
  • ora-02835 : Server unable to send signal to client
  • ora-29914 : ODCIGETINTERFACES routine does not return required stream version
  • ora-24280 : invalid input value for parameter string
  • ora-02465 : Inappropriate use of the HASH IS option
  • ora-25139 : invalid option for CREATE TEMPORARY TABLESPACE
  • ora-25130 : cannot modify primary key - primary key not defined for table
  • ora-38415 : invalid name or datatype for the attribute: string
  • ora-02324 : more than one column in the SELECT list of THE subquery
  • ora-01617 : cannot mount: string is not a valid thread number
  • ora-38610 : FI "string" name prefix is reserved for frequent itemset counting
  • ora-32838 : exceeded maximum number of properties
  • ora-36700 : (XSRELTBL04) Dimension workspace object cannot be qualified more than once.
  • ora-38408 : The ADT "string" does not exist in the current schema.
  • ora-37041 : (XSACQUIRE_DEP_TIMEOUT) Composite, concat, dimension map, or internal partition workspace object is locked by another user and the WAIT timed out.
  • ora-16186 : Modifying LOG_ARCHIVE_CONFIG requires SID='*' qualifier
  • ora-30072 : invalid time zone value
  • ora-32550 : Replacement occured despite hint to the contrary
  • ora-14190 : only one ENABLE/DISABLE ROW MOVEMENT clause can be specified
  • 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.