select ‘alter table ‘||table_owner||’.’||table_name||’ rename partition ‘||partition_name||’ to ‘||’PART_’||substr(partition_name,-8)||’;’
from dba_tab_partitions
where table_name in (‘TABLO1′,’TABLO2’)

select ‘alter table ‘||table_owner||’.’||table_name||’ rename subpartition ‘||subpartition_name||’ to ‘||’SPART_’||substr(partition_name,-8)||’_’||trim(to_char(subpartition_position,’000′))||’;’
from dba_tab_subpartitions
where table_name in (‘TABLO1′,’TABLO2’)

Reklamlar