Version Verification during Oracle expdp/impdp Import

1. The data file is exported by oracle11g using expdp and the lowest version, and imported by Oracle10g

Export Statement:

EXPDP USER_A/USER_A@NSDEV DIRECTORY=EXPDP_FILE DUMPFILE=USER_A_10G.DMP LOGFILE=USER_A_10G.LOG SCHEMALS=USER_A VERSION=10

 

Import Statement:

IMPDP USER_A/USER_A@NSDEV DIRECTORY=IMPDP_FILE DUMPFILE=USER_A_10G.DMP LOGFILE=USER_AIMP_10G.LOG

 

Verification Result:

1. Db_link is not imported. Therefore, you need to manually create db_link after importing.
2. The data files exported with version 11G are much larger than those exported without version.
3. Oracle10g, you can use impdp to import data files generated after the expdp version is added on 11g.

 

2. The data file is exported by Oracle10g using expdp and then imported by oracle11g to verify the downward compatibility of the 11g.

Execution statement

IMPDP USER_A/USER_A@192.168.0.6:1521/NSDEV DIRECTORY=EXPDP_DIR DUMPFILE=USER_A.TAB.DMP LOGFILE=USER_A.TAB.LOG SCHEMAS=USER_A REMAP_SCHEMA=USER_A:SCOTT REMAP_TABLESPACE=NSTC_WS:USERS

 

Verification Result:

1. Verified and usable

3. Summary

• The content exported by Oracle later versions through expdp must be imported by the same version of Oracle. Otherwise, a version number is required. For example, if the content library exported using expdp of oracle11.2.2 is imported using oracle11.1.1, version incompatibility is thrown. If you add version = 11 to the export, you can specify a major version.
• Databases exported from earlier Oracle versions through expdp can be directly compatible with later versions.

 

References

• Http://blog.sina.com.cn/s/blog_5016113a0100af5q.html
• Http://www.cnblogs.com/lanzi/archive/2011/01/06/1927731.html
• Http://space.itpub.net/11990065/viewspace-702119
• Http://space.itpub.net/23898243/viewspace-693998
• Http://space.itpub.net/17203031/viewspace-694740
• Http://blog.sina.com.cn/s/blog_7d5ee55e0100trfk.html
• Http://wenku.baidu.com/view/874f5182d4d8d15abe234e4a.html