ORA-29952: cannot issue DDL on a domain index partition
marked as LOADING



ORA-29952: cannot issue DDL on a domain index partition marked as LOADING..

Answer / guest

Cause: Tried to issue a DROP/ALTER/TRUNCATE on a domain
index partition in a LOADING state.

Action: Wait till the index partition operation completes OR
issue a DROP INDEX FORCE to drop the index OR issue a ALTER
TABLE DROP PARTITION to drop the partition.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

TNS-01044: %s(Registered) has string service handler(s)

1 Answers  


NID-00310: Control File string - reverted

1 Answers  


ORA-01867: the interval is invalid

1 Answers  


RMAN-06060: WARNING: skipping datafile compromises tablespace string recoverability

1 Answers  


ORA-09272: remote os logon is not allowed

1 Answers  


ORA-07574: szrfc: $GETUAI failure

1 Answers  


ORA-30768: Cannot evaluate pipelined function

1 Answers  


NNL-00340: Trace file name is currently string

1 Answers  


ORA-19583: conversation terminated due to error

1 Answers  


RMAN-08162: executing Memory Script

1 Answers  


QSM-02125: subquery join conditions don't meet requirements for capability

1 Answers  


VID-00703: unable to read video data

1 Answers  


Categories