Přikládám sled kroků, které je potřeba udělat, chcete-li přenést tabulku do jiného tablespacu.
SQL> SELECT OWNER, TABLE_NAME,TABLESPACE_NAME,STATUSFROM dba_tablesWHERE TABLE_NAME =’TBLTEST’UNION ALLSELECT OWNER, INDEX_NAME,TABLESPACE_NAME,STATUSFROM dba_indexesWHERE TABLE_NAME = ‘TBLTEST’/ OWNER TABLE_NAME—————————— ——————————TABLESPACE_NAME STATUS—————————— ——–TBS_ADM TBLTESTTBS_MAIN VALIDTBS_ADM PK_TBLTESTTBS_IDX VALID
Elapsed: 00:00:00.06SQL> ALTER TABLE TBS_ADM.TBLTEST MOVE TABLESPACE TBS_DATA;Table altered.Elapsed: 00:00:01.26SQL> SELECT OWNER, TABLE_NAME,TABLESPACE_NAME,STATUSFROM dba_tablesWHERE TABLE_NAME =’TBLTEST’UNION ALLSELECT OWNER, INDEX_NAME,TABLESPACE_NAME,STATUSFROM dba_indexesWHERE TABLE_NAME = ‘TBLTEST’/ OWNER TABLE_NAME—————————— ——————————TABLESPACE_NAME STATUS—————————— ——–TBS_ADM TBLTESTTBS_DATA VALIDTBS_ADM PK_TBLTESTTBS_IDX UNUSABLEElapsed: 00:00:00.01SQL> ALTER INDEX TBS_ADM.PK_TBLTEST REBUILD;Index altered.Elapsed: 00:00:00.70SQL> SELECT OWNER, TABLE_NAME,TABLESPACE_NAME,STATUSFROM dba_tablesWHERE TABLE_NAME =’TBLTEST’UNION ALLSELECT OWNER, INDEX_NAME,TABLESPACE_NAME,STATUSFROM dba_indexesWHERE TABLE_NAME = ‘TBLTEST’/ OWNER TABLE_NAME—————————— ——————————TABLESPACE_NAME STATUS—————————— ——–TBS_ADM TBLTESTTBS_DATA VALIDTBS_ADM PK_TBLTESTTBS_IDX VALIDElapsed: 00:00:00.01