Oracle Database Discussions

Hi ,

DB version is 10.2.0.4 . Trying to drop tablespace it throws error as

SQL> drop tablespace APPS_TS_SUMMARY including contents and datafiles;
drop tablespace APPS_TS_SUMMARY including contents and datafiles
*
ERROR at line 1:
ORA-23515: materialized views and/or their indices exist in the tablespace


SQL> !oerr ora 23515
23515, 00000, "materialized views and/or their indices exist in the tablespace"
// *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.
//

So dropped the MV in the tablespace using,

select 'drop materialized view '||owner||'.'||name||' ;' from dba_registered_snapshots where name in (select table_name from dba_tables where tablespace_name='APPS_TS_SUMMARY');

Then too it showed the same error. How do i drop this tablespace?

baskar.l