Saturday, February 27, 2016

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


Make list of  MATERIALIZED  view:
===================================


select 'drop materialized view  '|| a.owner||'.'|| a.object_name || ';' from dba_objects a ,dba_segments b where a.OWNER=b.OWNER and b.TABLESPACE_NAME='MGMT_TABLESPACE'  and object_type='MATERIALIZED VIEW';
drop materialized view SYSMAN.MGMT$ARU_PATCH_RECOM_MD;

No comments:

Post a Comment

How to troubleshoot and get to know about current top wait events since oracle database instance startup ?

  To get the current top wait events since instance startup , use: SELECT * FROM ( SELECT event, total_waits, ROUND(time_waited_micro/100000...