Migrate from 9i to 10g by using transport tablespace feature
Migrate 9i db to 10g quickly by using transport tablespace features.
Below is test steps.
1. check self contained of tablespace
EXECUTE DBMS_TTS.TRANSPORT_SET_CHECK('ALAMEDA_DATA', TRUE);
SELECT * FROM TRANSPORT_SET_VIOLATIONS;
2. change tablespace read only
alter tablespace test read only;
3. exp tablespace metadata
exp \"sys/sys as sysdba\" transport_tablespace=y tablespaces=(ALAMEDA_DATA) file=alameda.dmp log=alameda.log
4. copy the tablespace file to another place
5. imp tablespace to 10g db
imp \"sys/sys as sysdba\" transport_tablespace=y tablespaces=(ALAMEDA_DATA) file='alameda.dmp' datafiles=('E:\ORACLE\ORADATA\ORA60\ALAMEDA10g_DATA03.DBF','D:\ORACLE\ORADATA\ORA60\ALAMEDA10g_DATA04.DBF','E:\ORACLE\ORADATA\ORA60\ALAMEDA10g_DATA01.DBF','E:\ORACLE\ORADATA\ORA60\ALAMEDA10g_DATA02.DBF') tts_owners=(alameda,alamedapre) fromuser=(alameda,alamedapre) touser=(alameda,alamedapre) log=tts_i.log
6. change tablespace read write
alter tablespace alameda read write;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/27143/viewspace-366334/ ，如需转载，请注明出处，否则将追究法律责任。
