ORA-39921: Default Partition (Table) Tablespace USERS for TP not contained in transportable set

来源:互联网 发布:网络可用,电脑连接不上 编辑:程序博客网 时间:2024/05/16 11:05

When doing transportable tablespace, I get the following errors when run the TTS set check procedure:

SQL> EXECUTE dbms_tts.transport_set_check('TS_D1,TS_D2,TS_D3,TS_D4',TRUE); 

PL/SQL procedure successfully completed.

SQL> select * from sys.transport_set_violations;


VIOLATIONS
------------------------------------------------------------------------------------------------
ORA-39921: Default Partition (Table) Tablespace USERS for TP not contained in transportable set.

    The problem is that the default tablespace of the partition table is not in the tablespace we need transported, we should change it:

ALTER TABLE ... MODIFY DEFAULT ATTRIBUTES TABLESPACE ...; 
ALTER TABLE TP MODIFY DEFAULT ATTRIBUTES TABLESPACE ts_d1;

After I change it, I run the TTS set check procedure again,it's OK:

SQL> EXECUTE dbms_tts.transport_set_check('TS_D1,TS_D2,TS_D3,TS_D4',TRUE); 

PL/SQL procedure successfully completed.

SQL> select * from sys.transport_set_violations;

no rows selected

原创粉丝点击