1、转移表空间
SELECT 'ALTER TABLE '||TABLE_NAME||' MOVE TABLESPACE 表空间;' FROM USER_TABLES;
2、重建索引
SELECT 'ALTER INDEX ' || INDEX_NAME || ' REBUILD;' FROM USER_INDEXES WHERE TABLE_OWNER = '用户名';
3、转移LOB字段
SELECT 'ALTER TABLE '||TABLE_NAME||' MOVE LOB('||COLUMN_NAME||') STORE AS (TABLESPACE 表空间);',COLUMN_NAME
FROM ALL_TAB_COLUMNS WHERE OWNER = '用户名' AND DATA_TYPE IN ('CLOB','BLOB')