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
- ORA-39921: Default Partition (Table) Tablespace USERS for TP not contained in transportable set
- ORA-14099 : all rows in table do not qualify for specified partition & ORA-14126
- ORA-14099: all rows in table do not qualify for specified partition
- ORA-01653: unable to extend table STEVEN3.FOXT_RESULT by 8192 in tablespace USERS
- Default Tablespace(USERS)
- ORA-01688:unable to extend table name。name partition NAME by NUM in tablespace NAME
- ORA-01536: space quota exceed for tablespace "USERS"
- oracle ORA-01536: space quota exceeded for tablespace 'USERS'
- ora-01536:space quota exceeded for tablespace 'users'
- transportable tablespace
- ORA-12919: Can not drop the default permanent tablespace
- You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows: Warning (
- 20.You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows:
- ORA-14404: partitioned table contains partitions in a different tablespace
- Error: Table ad for model Ad was not found in datasource default.
- ORA-01552: cannot use system rollback segment for non-system tablespace 'USERS'
- ORA-01950:no privileges on tablespace 'USERS'
- ORA-01950:no privileges on tablespace 'USERS'
- apache php localhost,127.0.0.1可以访问,ip不可以访问
- 大话设计模式笔记
- HDU 1864 最大报销额
- android 分辨率自适应
- 用iframe设置代理解决ajax跨域问题
- ORA-39921: Default Partition (Table) Tablespace USERS for TP not contained in transportable set
- PHP----MIME.php-----文件上传类型集
- 电子书推荐--《Python灰帽子》,python黑客编程
- VC_继承和派生
- 【代码】PHP 分析查询MySQL大量数据的内存占用情况
- Java "equals"和"=="的区别
- SWT/Jface StyledText 的Traverse,VerifyKey,MouseListener分析
- SQL各种连接
- Myeclipse调试2