Before:
PT_Table:EMP
P1_Tablespace:PTS1
P2_Tablespace:PTS2
After:
PT_Table:EMP
P1_Tablespace:PTS1
P2_Tablespace:PTS2
PTS1 TTS to NewDB.
Action:
create tablespace fortts datafile size 50m;
connect emp
create table EMP_TTS(...) tablespace fortts;
alter table EMP exchange partition P1 with table EMP_TTS;
exec DBMS_TTS.TRANSPORT_SET_CHECK('users',TRUE);
select * from transport_set_violations;
alter tablespace PTS1 read only;
exp file=/.../EMP_P1_data.dmp transport_tablespace=y constraints=n tablespaces=PTS1
select * from V$transportable_platform;
rman target /
convert tablespace PTS1 to platform. 'Solaris[tm] OE (64-bit)' format='/.../PTS1_Solaris.dbf';
scp
alter tablespace PTS1 read write ;
connect emp
alter table EMP exchange partition P1 with table EMP_TTS;
imp file=/.../EMP_P1_data.dmp transport_tablespace=y tablespaces=PTS1 datafiles='/.../PTS1_Solaris.dbf' tts_onwers=(emp)
alter tablespace PTS1 read write ;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16348200/viewspace-543145/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/16348200/viewspace-543145/