2017-03-14

Move To Anthor Tablespace

– ALTER TABLESPACE PRLS_DATA OFFLINE NORMAL;

select ‘ALTER TABLE ‘ || OWNER || ‘.’ || TABLE_NAME || ‘ MOVE TABLESPACE ‘ || ‘DESTINATION_TABLESPACE’ || ‘;’ from DBA_TABLES WHERE OWNER = ‘XX’;

select ‘ALTER INDEX ‘ || OWNER || ‘.’ || INDEX_NAME || ‘ REBUILD TABLESPACE ‘ || ‘DESTINATION_TABLESPACE’ || ‘;’ from DBA_INDEXES WHERE OWNER = ‘XX’;

– ALTER TABLESPACE PRLS_DATA ONLINE;

Change default tablespace
alter user xx
default tablespace DESTINATION_TABLESPACE;