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

DRG-11807: No Content

1 Answers  


NNL-00304: Server flushing its cache

1 Answers  


TNS-12528: TNS:listener: all appropriate instances are blocking new connections

1 Answers  


ORA-06575: Package or function string is in an invalid state

1 Answers  


TNS-04232: Trace Assistant WARNING: Not retrieving all rows

1 Answers  






ORA-12715: invalid character set specified

1 Answers  


ORA-01303: subordinate process error: number. Check alert and trace logs

1 Answers  


ORA-02739: osncon: host alias is too long

1 Answers  


LPX-00602: Invalid child element '~1S' of element '~2S'.

1 Answers  


ORA-24129: table name string does not start with string prefix

1 Answers  


TNS-12547: TNS:lost contact

1 Answers  


PCC-02013: unknown escape sequence

1 Answers  


Categories