DBA Data[Home] [Help]

APPS.MSC_UTIL dependencies on FND_TABLESPACES

Line 1553: select tablespace into lv_Nologging_tblsp from FND_TABLESPACES where tablespace_type = 'NOLOGGING';

1549: DROP_MVIEW_SYNONYMS(i.mview_owner, i.mview_name);
1550: end loop;
1551:
1552: -- drop MVs which are not in NOLLOGING tblspc
1553: select tablespace into lv_Nologging_tblsp from FND_TABLESPACES where tablespace_type = 'NOLOGGING';
1554: FOR j IN(select a.mview_name,c.table_name,c.TABLESPACE_NAME
1555: from MSC_COLL_SNAPSHOTS_V a, ALL_MVIEWS b,ALL_TABLES c
1556: where a.mview_name = b.mview_name
1557: AND b.OWNER = G_APPS_SCHEMA