APPS.BSC_MIGRATION dependencies on ALL_TAB_PARTITIONS

Line 856: -- storage parameters from all_tab_partitions

852: ELSE
853: -- The source system is Enterprice version (APPS)
854: IF x_with_partitions THEN
855: -- See if the table has partitions in the source. In this case we need to read
856: -- storage parameters from all_tab_partitions
857: h_count := 0;
858: h_sql := 'select count(*)'||
859: ' from all_tab_partitions@'||g_db_link||
860: ' where table_owner = :1 and table_name = :2';

Line 859: ' from all_tab_partitions@'||g_db_link||

855: -- See if the table has partitions in the source. In this case we need to read
856: -- storage parameters from all_tab_partitions
857: h_count := 0;
858: h_sql := 'select count(*)'||
859: ' from all_tab_partitions@'||g_db_link||
860: ' where table_owner = :1 and table_name = :2';
861: OPEN h_cursor FOR h_sql USING g_src_bsc_schema, h_table;
862: FETCH h_cursor INTO h_count;
863: CLOSE h_cursor;

Line 867: ' from all_tab_partitions@'||g_db_link||

863: CLOSE h_cursor;
864:
865: IF h_count > 0 THEN
866: h_sql := 'select max(initial_extent), max(next_extent), max(max_extent), max(pct_increase)'||
867: ' from all_tab_partitions@'||g_db_link||
868: ' where table_owner = :1 and table_name = :2';
869: OPEN h_cursor FOR h_sql USING g_src_bsc_schema, h_table;
870: ELSE
871: h_sql := 'SELECT initial_extent, next_extent, max_extents, pct_increase'||

Line 1709: from all_tab_partitions

1705: --Bug#4769877: need to use LOCAL if the table is partitioned
1706: IF h_index_type = 'BITMAP' THEN
1707: select count(partition_name)
1708: into h_count
1709: from all_tab_partitions
1710: where table_owner = g_src_bsc_schema and table_name = x_table;
1711:
1712: IF h_count > 0 THEN
1713: h_sql := h_sql||' LOCAL';