ORA-29856: error occurred in the execution of ODCIINDEXDROP
routine
Answers were Sorted based on User's Feedback
Answer / guest
Cause: Failed to successfully execute the ODCIIndexDrop routine.
Action: Check to see if the routine has been coded correctly.
Please add more information about this Error
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / tauseef ur rehman
use command
drop index index_name force
Hope this will resolve your problem
| Is This Answer Correct ? | 0 Yes | 2 No |
NNO-00806: Error: OCI_ERROR: string
ORA-02822: Invalid block offset
ORA-12482: internal MLS error: string Error: string
ORA-13225: specified index table name is too long for a spatial index
UDI-00004: operation generated ORACLE error number
TNS-12547: TNS:lost contact
ORA-02143: invalid STORAGE option
ORA-25282: message id. not provided for non-repudiation
IMG-00847: area list allocation failed
NID-00110: Cannot use REVERT and specify a database name at the same time
ORA-39104: cannot call this function from a SQL parallel query slave process
ORA-19645: datafile string: incremental-start SCN is prior to creation SCN string