DBA Data[Home] [Help]

APPS.MSC_UTIL dependencies on DBA_TABLES

Line 537: DBA_TABLESPACES dt

533: lv_initial_extent,
534: lv_next_extent ,
535: lv_extent_management
536: FROM ALL_TABLES alt,
537: DBA_TABLESPACES dt
538: WHERE alt.table_name = upper(p_table_name)
539: AND alt.owner = upper(p_schema)
540: AND alt.tablespace_name = dt.tablespace_name ;
541: BEGIN

Line 581: DBA_TABLESPACES dt

577: INTO lv_initial_extent,
578: lv_next_extent ,
579: lv_extent_management
580: FROM ALL_TABLES alt,
581: DBA_TABLESPACES dt
582: WHERE alt.table_name = upper(p_table_name)
583: AND alt.owner = upper(p_schema)
584: AND alt.tablespace_name = dt.tablespace_name ;
585: IF v_index_space is NULL THEN

Line 1604: FROM sys.dba_tables dt

1600: lv_sql_stmt VARCHAR2(1000);
1601:
1602: CURSOR tabWithoutMV IS
1603: SELECT table_name,owner
1604: FROM sys.dba_tables dt
1605: WHERE table_name IN (SELECT mview_name
1606: FROM msc_coll_snapshots_v)
1607: AND NOT EXISTS (SELECT 1
1608: FROM sys.dba_objects do