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

Why exactly oracle huge page do not help I/O improvement ?

  One-line explanation HugePages make Oracle’s SGA memory easier for the OS and CPU to manage, but they do not make the disk, SAN, ASM, or f...