Thursday, 17 May 2012

ORA-29964: missing ADD or DROP keyword

ORA-29964: missing ADD or DROP keyword

Cause: One of the keywords ADD or DROP is expected.

Action: Specify the ADD or DROP keyword or check the SQL statement.

ORA-29963: missing BINDING keyword

ORA-29963: missing BINDING keyword

Cause: Keyword BINDING is expected .

Action: Specify the BINDING keyword or check the SQL statement.

ORA-29962: fatal error occurred in the execution of ODCIINDEXALTER routine

ORA-29962: fatal error occurred in the execution of ODCIINDEXALTER routine

Cause: Failed to successfully execute the ODCIIndexAlter routine.

Action: Check to see if the routine has been coded correctly.

ORA-29961: too many warnings occurred in the execution of ODCIIndex DDL routine

ORA-29961: too many warnings occurred in the execution of ODCIIndex DDL routine

Cause: The number of warnings during the ODCIIndex DDL routine is too high.

Action: Query table SYS.ODCI_WARNINGS$ to get more warning messages

ORA-29960: line string, string

ORA-29960: line string, string

Cause: The ODCIIndex DDL routine has put a warning message into table SYS.ODCI_WARNINGS$

Action: Check the warning message

ORA-29959: error in the execution of the string routine for one or more of the index partitions

ORA-29959: error in the execution of the string routine for one or more of the index partitions

Cause: An error occurred during execution of the routine for one or more of the index partitions

Action: Check the *_IND_PARTITIONS view to see which partitions are marked FAILED. Rebuild or Truncate the FAILED index partitions

ORA-29958: fatal error occurred in the execution of ODCIINDEXCREATE routine

ORA-29958: fatal error occurred in the execution of ODCIINDEXCREATE routine

Cause: Failed to successfully execute the ODCIIndexCreate routine.

Action: Check to see if the routine has been coded correctly.