Oracle's imp/exp component is a common tool. One of its operational principles is
Backward compatibility. The following are the usage rules and related tests summarized as follows:
Rule 1: earlier versions of exp/imp can be connected to database servers of higher versions (or the same version), but later versions of exp/imp cannot be connected to database servers of lower versions-- 1.1 Use the 9i client to connect to the 10g Database C: \ Documents ents and Settings \ yuechaotian> exp userid = hdtest/test @ s67 tables = (ab01) rows = n file = d: \ x. dmpExport: Release 9.2.0.1.0-Production on Wednesday 10:09:55 2008 Copyright (c) 1982,200 2, Oracle Corporation. all rights reserved. connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the Partitioning, OLAP and Data Mining options
The ZHS16GBK and AL16UTF16 NCHAR character sets have been exported.
Note: No table data (rows) will be exported to the specified table through the regular path...
... Exporting table AB01...
The export is successfully terminated without warning. -- 1.2 use a 10g client to connect to the 9i Database through imp: Connection Failed (instead of export failed) C: \ Documents and Settings \ yuechaotian> exp userid = hbjb_kf_hd/test @ s46 owner = hdtest file = d: \ x. dmpExport: Release 10.2.0.1.0-Production on Wednesday 09:57:22 2008 Copyright (c) 1982,200 5, Oracle. all rights reserved. EXP-00056: ORACLE error 6550
ORA-06550: 1st rows, 41st columns:
PLS-00302: The ''set _ NO_OUTLINES ''component must be described
ORA-06550: 1st rows, 15th columns:
PL/SQL: Statement ignored
EXP-00000: Export termination failed
Rule 2: A dmp file generated in a later version exp. An imp file cannot be identified in a later version)-- 2.1 use the 10g client exp to output 10g Data C: \ Documents ents and Settings \ yuechaotian> exp userid = test/test @ orcl owner = test file = d: \ 10g. dmpExport: Release 10.2.0.1.0-Production on Wednesday 11:16:39 2008 Copyright (c) 1982,200 5, Oracle. all rights reserved. connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the Partitioning, OLAP and Data Mining options
The ZHS16GBK and AL16UTF16 NCHAR character sets have been exported.
The server uses the AL32UTF8 character set (possible Character Set conversion) to export the specified user ......... The export is successfully terminated, but a warning is displayed. C: \ Documents and Settings \ yuechaotian> -- 2.2 Use the dmp file exported above the 9i client imp to connect to 10 Gb, but cannot identify the file C: \ Documents and Settings \ yuechaotian> imp userid = test/test @ s10g fromuser = test touser = test file = d: \ 10g. dmpImport: Release 9.2.0.1.0-Production on Wednesday February 20 11:20:33 2008 Copyright (c) 1982,200 2, Oracle Corporation. all rights reserved.
Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the Partitioning, OLAP and Data Mining optionsIMP-00010: Not a valid export file, title Verification Failed
IMP-00000: failed to terminate import of C: \ Documents ents and Settings \ yuechaotian>
Rule 3: dmp files generated in earlier versions exp. Later versions can be imp (backward compatible)-- 3.1 Use 9i client exp to output data C: \ Documents ents and Settings \ yuechaotian> exp userid = test/test @ s9i owner = test file = d: \ 9i. dmpExport: Release 9.2.0.1.0-Production on Wednesday 11:25:04 2008 Copyright (c) 1982,200 2, Oracle Corporation. all rights reserved.
Connect to: Oracle9i Enterprise Edition Release 9.2.0.1.0-Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0-Production
The ZHS16GBK Character Set and AL16UTF16 NCHAR character set have been exported. The specified user will be exported soon ......... The export is successfully terminated without warning. C: \ Documents and Settings \ yuechaotian> -- 3.2 use 10g client imp to 10g Database C: \ Documents and Settings \ yuechaotian> imp userid = test/test @ orcl fromuser = test touser = test file = d: \ 9i. dmpImport: Release 10.2.0.1.0-Production on Wednesday 11:28:46 2008 Copyright (c) 1982,200 5, Oracle. all rights reserved.
Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the Partitioning, OLAP and Data Mining options EXPORT files created by EXPORT: V09.02.00 in the conventional path
The ZHS16GBK Character Set and AL16UTF16 NCHAR character set have been imported.
The import server uses the AL32UTF8 character set (possible Character Set conversion)
... Importing table "AUDIT_ACTIONS" to import 144 rows ...... Import is terminated successfully, but a warning is displayed. C: \ Documents and Settings \ yuechaotian>
Rule 4: Data from earlier versions of Oracle can be imported to later versions of Oracle, but it is limited to adjacent versions of Oracle, such as from Oracle 7 to Oracle 8. For conversions between two non-adjacent versions, such as from Oracle 6 to Oracle 8, data should be first input to the intermediate version-Oracle 7, and then transferred from the intermediate database to a later version.
-- I use the 10g imp function to import the dmp file exported from 817 to 10g, which is different from the introduction of this rule. (This rule comes from the Oracle import and export tool for database transplantation in the high-tech architecture.) C: \ Documents and Settings \ yuechaotian> imp userid = test/test fromuser = scott touser = test file = d: \ tyc. dmpImport: Release 10.2.0.1.0-Production on Wednesday 14:03:33 2008 Copyright (c) 1982,200 5, Oracle. all rights reserved.
Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the Partitioning, OLAP and Data Mining options EXPORT files created by EXPORT: V08.01.07 in the conventional path warning: these objects are exported by SCOTT, instead of importing the ZHS16GBK Character Set and AL16UTF16 NCHAR Character Set
The import server uses the AL32UTF8 character set (possible Character Set conversion)
The export server uses the ZHS16GBK NCHAR character set (possible ncharset conversion)
. Importing SCOTT's object to TEST
.. Importing the table "ACCOUNT" into five rows
.. Importing 0 rows into table "BONUS "...
.. Importing the table "DEPT" into four rows
.. Importing 14 rows into table "EMP "...
.. Importing the table "RECEIPT" into 1 row
.. Importing table "SALGRADE" 5 rows
Constraints to be enabled...
Import terminated successfully. No warning is displayed. C: \ Documents ents and Settings \ yuechaotian> -- the above operations are also applicable to Oracle Xe 10 GB: C: \ Documents and Settings \ yuechaotian> imp userid = test/test fromuser = scott touser = test file = d: \ tyc. dmpImport: Release 10.2.0.1.0-Production on Wednesday 14:15:51 2008 Copyright (c) 1982,200 5, Oracle. all rights reserved. connect to: Oracle Database 10g Express Edition Release 10.2.0.1.0-Production EXPORT files created by EXPORT: V08.01.07 in the conventional path warning: these objects are exported by SCOTT, instead of importing the ZHS16GBK Character Set and AL16UTF16 NCHAR Character Set
The export server uses the ZHS16GBK NCHAR character set (possible ncharset conversion)
. Importing SCOTT's object to TEST
.. Importing the table "ACCOUNT" into five rows
.. Importing 0 rows into table "BONUS "...
.. Importing the table "DEPT" into four rows
.. Importing 14 rows into table "EMP "...
.. Importing the table "RECEIPT" into 1 row
.. Importing table "SALGRADE" 5 rows
Constraints to be enabled...
Import terminated successfully. No warning is displayed. C: \ Documents and Settings \ yuechaotian>
