[Home] [Help]
88: procedure alter_mv_logs(p_level in varchar2, p_owner in varchar2) is
89:
90: cursor c_mv_log_name is
91: select distinct log_table
92: from all_snapshot_logs
93: where master = p_level and log_owner = p_owner;
94:
95: cursor cCols(p_mv_log varchar2) is
96: select cols.column_name, cols.data_type, cols.data_length
114: )
115: minus
116: select column_name, data_type, data_length
117: from all_tab_columns
118: where table_name =(select distinct log_table from all_snapshot_logs where log_owner=p_owner and log_table=p_mv_log )
119: and owner=p_owner
120: and data_type='VARCHAR2';
121: l_datatype_with_length varchar2(100);
122:
197: ) return boolean is
198: ------------------------------------------
199: cursor c_mv_log_name (p_table_name varchar2, p_table_owner varchar2) is
200: select log_table
201: from all_snapshot_logs
202: where master = p_table_name and log_owner = p_table_owner;
203: ------------------------------------------
204: l_table_owner varchar2(80);
205: l_sql VARCHAR2(1000);