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

ORA-30155: An I/O Error occured during an OCIFile function call

1 Answers  


NZE-29227: Certificate is expired.

1 Answers  


ORA-14632: cannot specify PARALLEL clause when adding a List subpartition

1 Answers  


ORA-30391: the specified rewrite equivalence does not exist

1 Answers  


ORA-13504: No SYSAUX datafile clause specified

1 Answers  


ORA-24352: invalid COBOL display type passed into OCI call

1 Answers  


QSM-01582: Joining equivalence, string, with table, string, not possible

1 Answers  


DRG-10308: no server with the required string personality mask is running

1 Answers  


ORA-07273: sppst: invalid semaphore id.

1 Answers  


ORA-14155: missing PARTITION or SUBPARTITION keyword

2 Answers   IBM,


RMAN-08117: channel string: the autobackup does not contain an SPFILE

1 Answers  


ORA-15186: ASMLIB error function = [string], error = [string], mesg = [string]

1 Answers  


Categories