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-01713: The constraints on these types do not match

1 Answers  


ORA-07655: slsprom:$TRNLOG failure

1 Answers  


ORA-19757: could not resize change tracking file to string blocks

1 Answers  


ORA-31624: operation string not allowed when job in string state

1 Answers  


ORA-23373: object group "string"."string" does not exist

1 Answers  






ORA-13126: unable to determine class for spatial table string

1 Answers  


LPX-00305: missing token

1 Answers  


RMAN-08524: input controlfilecopy name=string

1 Answers  


TNS-01182: Listener rejected registration of service "string"

1 Answers  


ORA-13260: layer table string does not exist

1 Answers  


EXP-00020: failed to allocate memory of size number

2 Answers  


NNL-00525: Shows or sets the server's default-forwarding status

1 Answers  


Categories