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

Oracle 26 ai database free

 https://www.oracle.com/in/database/26ai/ Oracle 26 ai release  Oracle AI Database Free Want to get hands-on with Oracle AI Database 26ai—ab...