DBA Data[Home] [Help]

APPS.FND_GEN_MIG_CMDS dependencies on DBA_TAB_PARTITIONS

Line 316: FROM dba_tab_partitions

312: CURSOR tab_part_csr(l_owner VARCHAR2, l_table_name VARCHAR2) IS
313: SELECT partition_name,
314: tablespace_name,
315: logging
316: FROM dba_tab_partitions
317: WHERE table_owner = l_owner
318: AND table_name = l_table_name;
319:
320: -- Get all the LOB Partitions (SEGMENT and INDEX) for sizing

Line 1492: FROM dba_tab_partitions

1488: AND NVL(dt.temporary, 'N') = 'N';
1489:
1490: CURSOR part_tsp_csr(l_owner VARCHAR2, l_table_name VARCHAR2, l_tablespace_name VARCHAR2) IS
1491: SELECT '1'
1492: FROM dba_tab_partitions
1493: WHERE table_owner = l_owner
1494: AND table_name = l_table_name
1495: AND tablespace_name <> l_tablespace_name;
1496: l_dummy VARCHAR2(1);

Line 2028: FROM dba_tab_partitions

2024: AND dt.table_name NOT LIKE 'RUPD$%'; -- tables for snapshot logs
2025:
2026: CURSOR part_tsp_csr(l_owner VARCHAR2, l_table_name VARCHAR2, l_tablespace_name VARCHAR2) IS
2027: SELECT '1'
2028: FROM dba_tab_partitions
2029: WHERE table_owner = l_owner
2030: AND table_name = l_table_name
2031: AND tablespace_name <> l_tablespace_name;
2032: l_dummy VARCHAR2(1);