Hi Oracle gurus,
I need a dynamic script to add MAXVALUE partition to all 100 range partitioned tables in schema,each tables are having different Partition Key with different tablespace
Any suggestion please
Hi Oracle gurus,
I need a dynamic script to add MAXVALUE partition to all 100 range partitioned tables in schema,each tables are having different Partition Key with different tablespace
Any suggestion please
As in:
SELECT 'ALTER TABLE '||owner||'.'||table_name||' ...
from dba_tables where owner=''
and table_name in ('TAB1','TAB2','TAB3'...);