ORA-29857: domain indexes and/or secondary objects exist in
the tablespace



ORA-29857: domain indexes and/or secondary objects exist in the tablespace..

Answer / guest

Cause: An attempt was made to drop a tablespace which
contains secondary objects and/or domain indexes.

Action: Drop the domain indexes in his tablespace. Also,
find the domain indexes which created secondary objects in
this tablespace and drop them. Then try dropping the tablespace.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06110: changed controlfile copy unavailable

1 Answers  


ORA-26650: %s background process string might not be started successfully

1 Answers  


RMAN-11004: format requires %%c when duplexing

1 Answers  


ORA-07418: sfareq: Database writer got error in timing function.

1 Answers  


ORA-01520: number of data files to add (string) exceeds limit of string

1 Answers  






ORA-25291: Buffer does not exist for the specified queue

1 Answers  


NZE-28753: failure to terminate use of data source

1 Answers  


NNO-00050: serious errors in configuration data, server cannot run

1 Answers  


ORA-10585: Test recovery can not apply redo that may modify control file

1 Answers  


PLS-00647: attribute by name "string" conflicts with method by same name

1 Answers  


ORA-31511: name exceeds maximum length of 30 characters

1 Answers  


ORA-07200: slsid: oracle_sid not set.

1 Answers  


Categories