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-12219: section name missing

1 Answers  


SQL-02143: Target object has not been properly allocated

1 Answers  


ORA-30686: no dispatcher accepted TCP/IP connection request

1 Answers  


PLS-00650: invalid type for PARTITION/CLUSTER/ORDER BY clause

1 Answers  


ORA-32013: failure in verifying parameters from the restored SPFILE

1 Answers  






PLS-00616: type mismatch found at 'string' among result expressions in a CASE expression

1 Answers  


ORA-01517: log member: 'string'

1 Answers  


ORA-31161: element or attribute "string" cannot be stored out of line

1 Answers  


ORA-29962: fatal error occurred in the execution of ODCIINDEXALTER routine

1 Answers  


ORA-02720: osnfop: shmat failed

1 Answers  


ORA-31038: Invalid string value: "string"

1 Answers  


ORA-32301: object-relational materialized views must be primary key based

1 Answers  


Categories