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

最新推荐文章于 2024-04-03 14:10:59 发布

hffyxhjy

最新推荐文章于 2024-04-03 14:10:59 发布

阅读量4.8k

点赞数

CC 4.0 BY-SA版权

分类专栏： oracle fundamental

本文链接：https://blog.youkuaiyun.com/haofeifei6/article/details/16801879

oracle fundamental 专栏收录该内容

30 篇文章

订阅专栏

本文介绍了解决Oracle数据库中运输表空间(TTS)时出现的ORA-39921错误的方法。通过更改分区表的默认表空间，确保其包含在所需的运输集内，最终解决了运输检查过程中的违规问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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