[Home] [Help]
1712: -- for seed data sync FCET, update least indexed smallest column in EV
1713: l_upd_ev_name := ad_zd_table.ev_view(l_table_name);
1714: select x.view_column_name into l_upd_column from
1715: ( select evc.view_column_name, count(idc.index_name), col.data_length
1716: from dba_tab_columns col, dba_ind_columns idc, dba_editioning_view_cols evc
1717: where col.owner = l_table_owner
1718: and col.table_name = l_table_name
1719: and evc.owner = col.owner
1720: and evc.view_name = l_upd_ev_name
1731: -- for ordinary FCET, update least indexed smallest column in base table
1732: l_upd_ev_name := NULL;
1733: select x.column_name into l_upd_column from
1734: ( select col.column_name, count(idc.index_name), col.data_length
1735: from dba_tab_columns col, dba_ind_columns idc
1736: where col.owner = l_table_owner
1737: and col.table_name = l_table_name
1738: and idc.table_owner(+) = col.owner
1739: and idc.table_name(+) = col.table_name
1826: L_FIRST boolean;
1827:
1828: cursor C_INDEX_COLUMNS(x_owner varchar2, x_name varchar2) is
1829: select idc.column_name
1830: from dba_ind_columns idc
1831: where idc.index_owner = x_owner
1832: and idc.index_name = x_name
1833: order by column_position;
1834: begin
1948: where idt.owner = idx.owner
1949: and idt.index_name = ad_zd_table.revised_index_name(idx.index_name) )
1950: and exists
1951: ( select col.column_name
1952: from dba_tab_columns col, dba_ind_columns idc
1953: where col.owner = idx.table_owner
1954: and col.table_name = idx.table_name
1955: and idc.index_owner = idx.owner
1956: and idc.index_name = idx.index_name
1966: where idt.owner = idx.owner
1967: and idt.index_name = ad_zd_table.revised_index_name(idx.index_name) )
1968: and exists
1969: ( select col.column_name
1970: from dba_tab_columns col, dba_ind_columns idc
1971: where col.owner = idx.table_owner
1972: and col.table_name = idx.table_name
1973: and idc.index_owner = idx.owner
1974: and idc.index_name = ad_zd_table.revised_index_name(idx.index_name)