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

ORA-16790: The value of the configurable property is invalid

1 Answers  


ORA-28115: policy with check option violation

1 Answers   Wipro,


ORA-15101: no action specified

1 Answers  


NNO-00261: cannot construct configuration checkpoint file name

1 Answers  


ORA-14069: invalid TABLESPACE_NUMBER value

1 Answers  


ORA-16156: LGWR archive log dependency not allowed if database is standby protected

1 Answers  


NCR-01018: NCRS: Encryption failure.

1 Answers  


ORA-24504: data length larger than expected

1 Answers  


ORA-40205: invalid setting name string

1 Answers  


ORA-00402: database changes by release string cannot be used by release string

1 Answers  


ORA-06119: NETTCP: spurious client request

1 Answers  


ORA-16629: Database reports a different protection level from the protection mode.

2 Answers  


Categories