1、查询表空间A的所有物化视图:
SELECT TABLE_NAME,TABLESPACE_NAME FROM DBA_TABLES WHERE TABLESPACE_NAME='A' AND TABLESPACE_NAME IN (SELECT MVIEW_NAME FROM DBA_MVIEWS);
2、删除物化视图(假定查询结果为:VIEW_A01):
DROP MATERIALIZED VIEW VIEW_A01;
1、查询表空间A的所有物化视图:
SELECT TABLE_NAME,TABLESPACE_NAME FROM DBA_TABLES WHERE TABLESPACE_NAME='A' AND TABLESPACE_NAME IN (SELECT MVIEW_NAME FROM DBA_MVIEWS);
2、删除物化视图(假定查询结果为:VIEW_A01):
DROP MATERIALIZED VIEW VIEW_A01;