1.File Corrupted During Transfer.
Note : FTP should be done in BINARY MODE
2.When export dump file is higher version and import in lower version.
then you must use 8.1.7 export tools for export data from 10.2.0.1.0.
and run CATEXP.SQL script.
Located : $ORACLE_HOME/rdbms/admin
Install Oracle 9i client and client Oracle 9i client to Oracle 10g server and export your database.
Export From
Version : 10.1.0.2.0 Version : 10.1.0.2.0 Version : 10.1.0.2.0 Version : 10.1.0.2.0
Export From
Version : 9.2.0.1.0 Version : 9.2.0.1.0 Version : 9.2.0.1.0 Version : 9.2.0.1.0
Export From
Version : 9.0.1.1.2 Version : 9.0.1.1.2 Version : 9.0.1.1.2
Export From
Version : 8.1.7.4
Export From
Version : 8.1.7.4 Version : 9.0.1.1.2
Version : 9.2.0.1.0
Version : 10.1.0.2.0
Version : 10.2.0.1.0
Export From
Version : 8.1.7.4 Version : 9.0.1.1.2
Version : 9.2.0.1.0
Export From
Version : 8.1.7.4 Version : 9.0.1.1.2
Above procedure and table is best practice to export and import but also consider below case.Dumpfile exported in Oracle 11gr1
Import in 10gr1, 9i, 8i
Then use Oracle 11gr1 client (IMPORT) binary to export 11g dumpfile.
Install oracle 11g client and connect to 10g,9i,8i server and import.
Dumpfile exported in Oracle 10g
Import in 9i,8i
Then use Oracle 10g client (IMPORT) binary to export 10g dumpfile
Install oracle 10g client and connect to 9i,8i server and import.
Dumpfile exported in Oracle 9i
Import in 8i
Then use Oracle 9i client (IMPORT) binary to export 9i dumpfile
Install oracle 9i client and connect to 8i server and import.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22779291/viewspace-695485/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22779291/viewspace-695485/