oracle export: 请有环境的朋友测试一下

zhyuh

环境同上

倒出：
$ exp lyf/lyf@ora8i file=lyf.dmp owner=lyf rows=y compress=n

Export: Release 7.3.4.0.0 - Production on Mon Nov  5 13:31:56 2001

Copyright (c) Oracle Corporation 1979, 1996.  All rights reserved.


Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Export done in ZHS16CGB231280 character set

About to export specified users ...
About to export LYF's objects ...
. exporting snapshots
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export LYF's tables via Conventional Path ...
. . exporting table                        MQ_BILL       2114 rows exported
. . exporting table                      MQ_BRANCH          2 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting referential integrity constraints
. exporting triggers
. exporting posttables actions
Export terminated successfully without warnings.


倒入：
$ imp system/manager@ora7 file=lyf.dmp fromuser=lyf touser=system

Import: Release 7.3.4.0.0 - Production on Mon Nov  5 13:34:19 2001

Copyright (c) Oracle Corporation 1979, 1996.  All rights reserved.


Connected to: Oracle7 Server Release 7.3.4.0.0 - Production
PL/SQL Release 2.3.4.0.0 - Production

Export file created by EXPORT:V07.03.04 via conventional path

Warning: the objects were exported by LYF, not by you

. . importing table                      "MQ_BILL"       2114 rows imported
. . importing table                    "MQ_BRANCH"          2 rows imported
Import terminated successfully without warnings

验证：
sqlplus system/manager@ora7
SQL> select count(*) from mq_bill;

  COUNT(*)
----------
      2114

SQL> select count(*) from mq_branch;
  COUNT(*)
----------
         2

结论：用户级别的倒入/倒出也可以

snowhite2000

thanks, zhyuh.

Cluster

1) Always use a version of the EXPORT utility that is equal to the
   lowest version of either the source or the target database.
2) Always use a version of the IMPORT utility that is equal to the
   version of the target database.