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 : 23-08-2017
ORA-30975

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

  • ora-16081 : insufficient number of processes for APPLY
  • ora-14289 : cannot make local index partition of Composite Range partitioned table unusable
  • ora-19860 : piece validation cannot be performed more than once
  • ora-25126 : Invalid name specified for BUFFER_POOL
  • ora-16555 : the Data Guard database is not active
  • ora-27071 : unable to seek to desired position in file
  • ora-16596 : object not part of the Data Guard broker configuration
  • ora-30382 : DROP MATERIALIZED VIEW string.string operation is not complete
  • ora-16757 : resource guard could not get property
  • ora-16619 : health check timed out
  • ora-22971 : invalid datatype for PRIMARY KEY-based object identifier
  • ora-22371 : Table contains data of type string.string, version string, which does not exist
  • ora-12531 : TNS:cannot allocate memory
  • ora-01080 : error in shutting down ORACLE
  • ora-32141 : get method does not match the type of the parameter
  • ora-26063 : Can not flashback to specified SCN value - Wrap: string Base: string.
  • ora-32774 : more than one file was specified for bigfile tablespace string
  • ora-04047 : object specified is incompatible with the flag specified
  • ora-00710 : new tablespace name is the same as the old tablespace name
  • ora-09293 : sksasmo: unable to send message to console
  • ora-25407 : connection terminated
  • ora-39040 : Schema expression "string" must identify exactly one schema.
  • ora-08006 : specified row no longer exists
  • ora-40003 : wordsize must be in the range string - string for BLAST-P
  • ora-30019 : Illegal rollback Segment operation in Automatic Undo mode
  • ora-36966 : (XSRELTBL10) workspace object must be a dimension.
  • ora-01504 : database name 'string' does not match parameter db_name 'string'
  • ora-06592 : CASE not found while executing CASE statement
  • ora-15091 : operation incompatible with open handle in this session
  • ora-31670 : Username argument must be specified and non-null.
  • 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.