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

Detailed 2-Node Oracle RAC Cluster architecture

  2-Node Oracle RAC Cluster architecture image with: RAC Node 1 and Node 2 physical servers Oracle Database instances Oracle Clusterware / ...