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博客 ” ,链接:http://blog.itpub.net/27143/viewspace-366334/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27143/viewspace-366334/