cursor c_table_list --cursor to tables need partition
is
select owner,
table_name,
partition_name,
tablespace_name,
tablespace_name_odd,
tablespace_name_even,
compression,
partition_count,
partition_date,
proc_flag_id,
deal_cycle,
partition_type_id,
tablespace_type_id,
last_day_type_id,
date_type_id
from LBI_SYS_VDF.t_s_tab_partition;
l_table_list c_table_list%rowtype;
is
select owner,
table_name,
partition_name,
tablespace_name,
tablespace_name_odd,
tablespace_name_even,
compression,
partition_count,
partition_date,
proc_flag_id,
deal_cycle,
partition_type_id,
tablespace_type_id,
last_day_type_id,
date_type_id
from LBI_SYS_VDF.t_s_tab_partition;
l_table_list c_table_list%rowtype;