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

ORA-12504: TNS:listener was not given the SID in CONNECT_DATA

1 Answers  


ORA-07402: sprst: cannot restore user signal handler.

1 Answers  


PCC-01008: Multiple element records not allowed in DECLARE section

1 Answers  


ORA-23602: Invalid streams process type string

1 Answers  


ORA-30175: invalid type given for an argument

1 Answers  






ORA-39086: cannot retrieve job information

1 Answers  


PCC-00087: EXEC SQL TYPE statement not allowed for this host language

1 Answers  


ORA-40105: input data incompatible with model signature

1 Answers  


ORA-30659: too many locations specified for external table

1 Answers  


ORA-32015: unable to restore SPFILE

1 Answers  


ORA-06815: TLI Driver: could not link SPX and IPX streams

1 Answers  


ORA-02151: invalid tablespace name: string

1 Answers  


Categories