问题
我们在将表分区所属表空间进行TTS操作前需要对相应表空间进行检查,会出现下面的信息
SQL> select * from sys.transport_set_violations;
VIOLATIONS
--------------------------------------------------------------------------------
Default Partition (Table) Tablespace USERS for ZZ not contained in transportable
set
Default Partition (Table) Tablespace USERS for ZZ not contained in transportable
set
处理方法
针对此问题,我们只需要修改表zz的属性就可以了。
alter table yy.zz modify default attributes tablespace aa;
就解决了上面的问题,再进行检查,就没有警告信息出现了,可以进行表空间传输了。
例子
SQL> create table zz(id number) partition by range(id)
2 (partition p1 values less than(10) tablespace aa,
3 partition p2 values less than(20) tablespace bb);
Table created.
SQL> insert into zz values(2);
1 row created.
SQL> insert into zz values (11);
1 row created.
SQL> commit;
Commit complete.
SQL> begin
2 dbms_tts.transport_set_check('aa,bb',true,true);
3 end;
4 /
PL/SQL procedure successfully completed.
SQL> select * from sys.transport_set_violations;
VIOLATIONS
--------------------------------------------------------------------------------
Default Partition (Table) Tablespace USERS for ZZ not contained in transportable
set
Default Partition (Table) Tablespace USERS for ZZ not contained in transportable
set
Default Partition (Table) Tablespace BB for ZZ not contained in transportable se
t
Default Partition (Table) Tablespace AA for ZZ not contained in transportable se
t
VIOLATIONS
--------------------------------------------------------------------------------
SQL> begin
2 dbms_tts.transport_set_check('aa,bb',true,true);
3 end;
4 /
PL/SQL procedure successfully completed.
SQL> select * from sys.transport_set_violations;
no rows selected
SQL>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/526592/viewspace-740628/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/526592/viewspace-740628/