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-29926: association already defined for the object

1 Answers  


ORA-12552: TNS:operation was interrupted

1 Answers  


ORA-21707: pin duration is longer than allocation duration

1 Answers  


ORA-08309: sllfop: Cannot fstat file

1 Answers  


RMAN-03040: Spooling for trace turned off

1 Answers  






ORA-23487: object groups "string"."string" and "string"."string" do not have the same connection qualifier

1 Answers  


PCC-00075: ":" expected before indicator variable

1 Answers  


ORA-12352: object string.string@string is invalid

1 Answers  


PCC-02424: The number of values and host variables does not match

1 Answers  


ORA-22600: encountered 8.0.2 (Beta) VARRAY data that cannot be processed

1 Answers  


ORA-22800: invalid user-defined type

1 Answers  


TNS-03503: Could not initialize NL

1 Answers  


Categories