Oracle Database Errors or Warnings from Error ORA-29951 to ORA-29960

SQLServerF1

ORA-29951: warning in the execution of ODCIINDEXSPLITPARTITION routine
Cause: A warning was returned from the ODCIIndexSplitPartition routine.
Action: Check to see if the routine has been coded correctly Check user specified log tables for greater detail.
ORA-29952: cannot issue DDL on a domain index partition marked as LOADING
Cause: Tried to issue a DROP/ALTER/TRUNCATE on a domain index partition in a LOADING state.
Action: Wait till the index partition operation completes OR issue a DROP INDEX FORCE to drop the index OR issue a ALTER TABLE DROP PARTITION to drop the partition.
ORA-29953: cannot issue DDL on a domain index partition marked as FAILED
Cause: Tried to issue a DROP/ALTER on a domain index partition in a FAILED state.
Action: do ALTER INDEX REBUILD PARTITION to rebuild the index partition OR ALTER TABLE TRUNCATE PARTITION to mark the index partition as valid.

ORA-29954: domain index partition is marked LOADING/FAILED/UNUSABLE
Cause: An attempt has been made to access a domain index that is being built or is marked failed by an unsuccessful DDL or is marked unusable by a DDL operation.
Action: Wait if the specified index partition is marked LOADING Rebuild the specified index partition if it is marked FAILED or UNUSABLE.
ORA-29955: error occurred in the execution of ODCIINDEXEXCHANGEPARTITION routine
Cause: Failed to successfully execute the ODCIIndexExchangePartition routine.
Action: Check to see if the routine has been coded correctly.
ORA-29956: warning in the execution of ODCIINDEXEXCHANGEPARTITION routine
Cause: A warning was returned from the ODCIIndexExchangePartition routine.
Action: Check to see if the routine has been coded correctly Check user specified log tables for greater detail.

ORA-29957: cannot create a function-based domain index on a string table
Cause: User specified an unsupported create function-based domain index statement.
Action: Issue the create function-based domain index statement only on supported types of tables.
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.
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-29960: line string, string
Cause: The ODCIIndex DDL routine has put a warning message into table SYS.ODCI_WARNINGS$
Action: Check the warning message

Above are list of Oracle Database Errors or Warnings from Error ORA-29951 to ORA-29960 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *