ORA-23515: materialized views and/or their indices exist in
the tablespace



ORA-23515: materialized views and/or their indices exist in the tablespace..

Answer / guest

Cause: An attempt was made to drop a tablespace which
contains materialized views and/or their indices.

Action: Drop the materialized views in this tablespace.
Also, find indices belonging to materialized views in this
tablespace and drop then. Then try dropping the tablespace.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

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

1 Answers  


UDE-00006: failed to allocate memory of size number

1 Answers  


ORA-31003: Parent string already contains child entry string

1 Answers  


TNS-00003: INTCTL: error while sending request to the Interchange

1 Answers  


ORA-31466: no publications found

1 Answers  






PLS-00567: cannot pass NULL to a NOT NULL constrained formal parameter

1 Answers  


PLS-00603: GROUPING function supported only with GROUP BY CUBE or ROLLUP

1 Answers  


ORA-26692: invalid value string, string should be in string format

1 Answers  


ORA-25299: Cannot add buffered subscriber for a non-buffered queue

1 Answers  


ORA-30553: The function is not deterministic

1 Answers  


ORA-31080: type not specified for attribute or element "string"

1 Answers  


NZE-28799: failure to allocate shared memory

1 Answers  


Categories