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
11603 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

ORA-14401: inserted partition key is outside specified partition

1 Answers

DRG-11410: could not insert into string result table

1 Answers

TNS-04050: Invalid specification for gateway ID.

1 Answers

ORA-09988: error while detaching SGA

1 Answers

LCD-00128: invalid positional parameter value [string]

1 Answers

ORA-13784: cannot accept SQL profiles for all statements in the "SQL Tuning Set"

1 Answers

ORA-00824: cannot set sga_target due to existing internal settings

1 Answers

IMG-00001: unable to initialize Oracle interMedia environment

1 Answers

PCC-00119: Value of const variable in INTO clause will be modified

1 Answers

ORA-26667: invalid STREAMS parameter string

1 Answers

ORA-38732: Expected file size string does not match string.

1 Answers

SQL*Loader-00942: partition string not part of table string

1 Answers

For more Oracle Errors Interview Questions Click Here