ORA-29856: error occurred in the execution of ODCIINDEXDROP
routine

Answers were Sorted based on User's Feedback



ORA-29856: error occurred in the execution of ODCIINDEXDROP routine..

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

ORA-29856: error occurred in the execution of ODCIINDEXDROP routine..

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

Post New Answer

More Oracle Errors Interview Questions

RMAN-06455: point-in-time tablespace recovery requires Enterprise Edition

1 Answers  


QSM-02045: START WITH clause in mv

1 Answers  


ORA-27418: syntax error in repeat interval

1 Answers  


NID-00301: Datafile string - dbid changed, wrote new name

1 Answers  


SQL*Loader-00504: Error skipping records in file (string)

1 Answers  






ORA-36685: (XSDPART23) Only CONCAT partition templates can be subpartitioned.

1 Answers  


ORA-10643: Database should be mounted in restricted mode and Exclusive mode

1 Answers  


ORA-01671: controlfile is a backup, cannot make a standby controlfile

1 Answers  


ORA-27212: some entrypoints in Media Management Library are missing

1 Answers  


SQL*Loader-00965: Error number disabling constraint string on table string

1 Answers  


NNL-00953: Cache lookup exact matches: number

1 Answers  


ORA-14456: cannot rebuild index on a temporary table

1 Answers  


Categories