Oracle个人技巧 -- 跨平台迁移

1.检查两个平台的endian格式
select d.platform_name,endian_format
from v$transportable_platform tp,v$database d
where tp.platform_name=d.platform_name;

2.确认该表是否可以传输
exec dbms_tts.transport_set_check('test',true);
select * from transport_set_violations;

3.对数据文件做一个备份
backup as copy datafile 11 format '/backup/aa.dbf';

4.利用备份产生的所需的文件
transport tablespace test
auxiliary destination '/backup/test/ad'
tablespace destination '/backup/test/td';

5.在目标库转换
convert datafile '/backup2/test/aa.dbf'
to platform 'Solaris [tm] OE (64-bit)'
from platform 'Solaris [tm] OE (64-bit)'
db_file_name_covert='/backup2/aa',;