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

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

Question Posted / guest

2 Answers
11826 Views
I also Faced
E-Mail Answers

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

TNS-00212: Total Pumps Started : number

1 Answers

ORA-07672: $PARSE_CLASS failed translating the string into a binary label

1 Answers

ORA-01511: error in renaming log/data files

1 Answers

PCC-02337: cannot declare multi-dimensioned array for this type

1 Answers

ORA-07601: spguno: $GETJPIW failure

1 Answers

ORA-23425: invalid materialized view identifier string

1 Answers

ORA-40004: penalty must be negative for BLAST-N

1 Answers

ORA-14153: only one of STORE IN or <partition-description> clause may be specified

1 Answers

ORA-25116: invalid block number specified in the DUMP DATAFILE/TEMPFILE command

1 Answers

RMAN-06587: one or more datafilecopies were not found

1 Answers

TNS-01400: Instance "string" has number handlers.

1 Answers

QSM-02188: named view in FROM list not supported for this type MV

1 Answers

For more Oracle Errors Interview Questions Click Here