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

UDE-00017: Data Pump job is already executing.

1 Answers  


RMAN-08531: channel string: proxy copy string is string in media management catalog

1 Answers  


TNS-03512: Used string adapter to resolve the alias

1 Answers  


LFI-00139: Option string cannot be used with option string in calling string.

1 Answers  


ORA-24130: table string does not exist

1 Answers  






RMAN-06280: Report of obsolete backups and copies

1 Answers  


ORA-01632: max # extents (string) reached in index string.string

1 Answers  


ORA-13293: cannot specify unit for geometry without a georeferenced SRID

1 Answers  


ORA-07242: slembfn: translation error, unable to translate error file name.

1 Answers  


ORA-12429: label list range exceeded

1 Answers  


ORA-25405: transaction status unknown

1 Answers  


LFI-00101: Write failed, file cannot be written to.

1 Answers  


Categories