SELECT owner, segment_name, partition_name, tablespace_name , 'ALTER TABLE '||a.segment_name||' move PARTITION '||a.partition_name||' tablespace TESTDB;' FROM dba_segments a WHERE 1=1 --AND owner = 'TEST' --AND tablespace_name = 'USERS' --AND segment_name like 'T_%' AND partition_name LIKE 'DATE%' ORDER BY segment_name ASC; select TABLE_OWNER,table_name,partition_name,tablespace_name ,'ALTER TABLE '||table_name||' move PARTITION '||partition_name||' tablespace TESTDB;' from dba_tab_partitions where tablespace_name = 'USERS' AND table_name LIKE'T_%'
表分区空间转移,乾坤大魔移。
- Oracle-TableSpace TableSpace Oracle Move Tooracle-tablespace tablespace oracle move oracle-tablespace tablespace generate creation oracle account odoo move to long_to_char字符 类型oracle 函数to_date oracle date tablespace converting tablespace regular large mainfabcoretest hist_indicator_profile tablespace tablespace错误exists mysql