以交互方式使用exp/imp的演示

众所周知,用exp/imp对数据库进行逻辑备份。包含表。用户,整个数据库,我们通常所熟悉的是使用命令行指定參数的方式来做的。以下我来演示一下不太经常使用的以交互方式的操作,操作非常easy。就是仅仅要输入exp/imp的命令,以交互方式提供导入导出所需的參数来完毕。尽管这样的方式没有实际的应用意义。但作为Oracle提供的一种方法,我们也是有必要熟悉一下的。

环境:Oracle 10.2.0.1/Linux Red Hat 5.3

一、单表导出导入測试

--创建測试表
[oracle@ora10g ~]$ sqlplus zlm/zlm
SQL> select username,default_tablespace from dba_users where username='ZLM';

USERNAME                       DEFAULT_TABLESPACE
------------------------------ ------------------------------
ZLM                            ZLM

SQL> create table t1 as select * from dba_objects;

Table created.

SQL> create table t2 as select * from user_objects;

Table created.

SQL> select count(*) from t1;

  COUNT(*)
----------
     50355

SQL> select count(*) from t2;

  COUNT(*)
----------
         2

SQL> !

注意,因为之前指定过zlm用户的缺省表空间为ZLM,因此这2个測试表是会创建到ZLM表空间中去的

--运行导出t1表
[oracle@ora10g ~]$ exp

Export: Release 10.2.0.1.0 - Production on 11 11:04:17 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Username: zlm
Password: 

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Enter array fetch buffer size: 4096 > 8192

Export file: expdat.dmp > t1.dmp    -指定导出的dmp文件名称

(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > t    --能够输入“T”,也能够输入“3”

Export table data (yes/no): yes > 

Compress extents (yes/no): yes > 

Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
Table(T) or Partition(T:P) to be exported: (RETURN to quit) >     --假设不输入表名直接回车表示会退出的,不导出不论什么表

Export terminated successfully without warnings.
[oracle@ora10g ~]$ exp    --因为刚才直接退出了,再又一次导一次

Export: Release 10.2.0.1.0 - Production on 11 11:05:00 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Username: zlm
Password: 

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Enter array fetch buffer size: 4096 > 8192    --指定buffer,默认是4k,这里指定了8k,实际使用时还能够设置更大的值,如1000000,即10M

Export file: expdat.dmp > t1.dmp

(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > 3

Export table data (yes/no): yes > 

Compress extents (yes/no): yes > 

Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > t1    --指定须要导出的t1測试表

. . exporting table                             T1      50355 rows exported
Table(T) or Partition(T:P) to be exported: (RETURN to quit) >     --没有其它想导出的表。就回车退出

Export terminated successfully without warnings.
[oracle@ora10g ~]$ exit
exit

--删除測试表t1
SQL> drop table t1 purge;

Table dropped.

SQL> select count(*) from t1;
select count(*) from t1
                     *
ERROR at line 1:
ORA-00942: table or view does not exist

--运行导入t1表
SQL> !
[oracle@ora10g ~]$ imp

Import: Release 10.2.0.1.0 - Production on 11 11:06:12 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Username: zlm
Password: 

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

Import file: expdat.dmp > t1.dmp    --指定刚才由exp生成的dmp文件作为导入的源

Enter insert buffer size (minimum is 8192) 30720>     --指定insert的buffer,直接回车採用默认值30720

Export file created by EXPORT:V10.02.01 via conventional path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
List contents of import file only (yes/no): no >    --默认是no。假设选择了yes。那么就没有下面3个选项了

Ignore create error due to object existence (yes/no): no > 

Import grants (yes/no): yes > 

Import table data (yes/no): yes > 

Import entire export file (yes/no): no > yes    --因为导出的时候不过对t1表单独的操作,所以选择yes也不过导入t1表而已

. importing ZLM's objects into ZLM
. importing ZLM's objects into ZLM
. . importing table                           "T1"      50355 rows imported
Import terminated successfully without warnings.
[oracle@ora10g ~]$ exit
exit

SQL> select count(*) from t1;

  COUNT(*)
----------
     50355

SQL> !

如今表已经成功地被又一次导入到数据库中的zlm用户中,相当于利用了原来对t1表的逻辑备份,对误删除的t1表进行恢复,假设再对已经存在的t1表运行一次导入操作。会发生什么情况呢?

[oracle@ora10g ~]$ imp

Import: Release 10.2.0.1.0 - Production on 11 11:07:12 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Username: zlm
Password: 

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

Import file: expdat.dmp > t1.dmp

Enter insert buffer size (minimum is 8192) 30720> 

Export file created by EXPORT:V10.02.01 via conventional path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
List contents of import file only (yes/no): no > yes
(选yes就没有了刚才的3个选项了)
Import entire export file (yes/no): no > yes    --依旧是选择导入整个导出文件t1.dmp(即:文件里仅有t1表的逻辑语句)

. importing ZLM's objects into ZLM
. importing ZLM's objects into ZLM
 "CREATE TABLE "T1" ("OWNER" VARCHAR2(30), "OBJECT_NAME" VARCHAR2(128), "SUBO"
 "BJECT_NAME" VARCHAR2(30), "OBJECT_ID" NUMBER, "DATA_OBJECT_ID" NUMBER, "OBJ"
 "ECT_TYPE" VARCHAR2(19), "CREATED" DATE, "LAST_DDL_TIME" DATE, "TIMESTAMP" V"
 "ARCHAR2(19), "STATUS" VARCHAR2(7), "TEMPORARY" VARCHAR2(1), "GENERATED" VAR"
 "CHAR2(1), "SECONDARY" VARCHAR2(1))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRA"
 "NS 255 STORAGE(INITIAL 6291456 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DE"
 "FAULT) TABLESPACE "ZLM" LOGGING NOCOMPRESS"
. . skipping table "T1"                               

Import terminated successfully without warnings.    

这里尽管提示“无警告地成功地结束了命令”,但并没有运行真正的导入,原因是之前的t1表已经存在,默认假设发生object existance的error。那么导入就会终止,这时候我们能够通过选择“Ignore create error due to object existence (yes/no): no > yes”来解决,这个交互模式中的yes就相当于我们熟悉的命令行中的參数ignore=y。表示使用追加的方式导入。并不会覆盖原来的数据,也不会由于对象已经存在而终止导入

[oracle@ora10g ~]$ imp

Import: Release 10.2.0.1.0 - Production on 11 11:07:38 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Username: zlm
Password: 

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

Import file: expdat.dmp > t1.dmp

Enter insert buffer size (minimum is 8192) 30720> 

Export file created by EXPORT:V10.02.01 via conventional path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
List contents of import file only (yes/no): no >     --选择no才干出现很多其它的參数选项,否则直接跳到是否导入整个文件

Ignore create error due to object existence (yes/no): no > yes

Import grants (yes/no): yes > 

Import table data (yes/no): yes > 

Import entire export file (yes/no): no > yes

. importing ZLM's objects into ZLM
. importing ZLM's objects into ZLM
. . importing table                           "T1"      50355 rows imported
Import terminated successfully without warnings.

相同是提示“无警告地成功地结束了命令”,但这次真正导出了t1表。我们看到了“"T1"      50355 rows imported”的字样

[oracle@ora10g ~]$ exit
exit

SQL> select count(*) from t1;

  COUNT(*)
----------
    100710

此时表中的数据为10W行,比原来的5W行多了一倍。由于又反复导入了一次,相当于把原来的数据又复制了一份。但要注意,假设表中有主键或者唯一约束的话就会报错。屏幕会马上显示诸如此类的错误:

Column 1 SYS
Column 2 I_DEPENDENCY2
Column 3 
Column 4 123
Column 5 123
Column 6 INDEX
Column 7 30-62005:19:10:18
Column 8 30-62005:19:10:18
Column 9 2005-06-30:19:10:18
Column 10 VALID
Column 11 N
Column 12 N
Column 13 N
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (ZLM.PK_OID) violated


二、多表导出导入測试

--导出2个測试表(t1,t2)到同一个dmp文件里
SQL> !
[oracle@ora10g ~]$ exp

Export: Release 10.2.0.1.0 - Production on 11 11:08:38 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Username: zlm
Password: 

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Enter array fetch buffer size: 4096 > 8192

Export file: expdat.dmp > t1_t2.dmp

(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > t

Export table data (yes/no): yes > 

Compress extents (yes/no): yes > 

Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > t1

. . exporting table                             T1     100710 rows exported
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > t2

. . exporting table                             T2          2 rows exported
Table(T) or Partition(T:P) to be exported: (RETURN to quit) >     --指定完所需导出的表后回车退出

Export terminated successfully without warnings.
[oracle@ora10g ~]$ exit
exit

--删除源表
SQL> drop table t1 purge;

Table dropped.

SQL> drop table t2 purge;

Table dropped.

--运行导入
SQL> !
[oracle@ora10g ~]$ imp

Import: Release 10.2.0.1.0 - Production on 11 11:09:38 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Username: zlm
Password: 

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

Import file: expdat.dmp > t1_t2.dmp

Enter insert buffer size (minimum is 8192) 30720> 

Export file created by EXPORT:V10.02.01 via conventional path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
List contents of import file only (yes/no): no > 

Ignore create error due to object existence (yes/no): no > 

Import grants (yes/no): yes > 

Import table data (yes/no): yes > 

Import entire export file (yes/no): no >     --有别于第一个单表导入的測试,这里假设选择了no。那么就能够分别指定须要导入的部分(t1_t2.dmp中含有t1,t2两个表的逻辑语句,可是如今仅仅导入t1)
Username: zlm

Enter table(T) or partition(T:P) names. Null list means all tables for user    --假设直接回车,就表示导入所有表
Enter table(T) or partition(T:P) name or . if done: t1

Enter table(T) or partition(T:P) name or . if done: .    --仅仅导入t1表,用“.”退出。注意。不是回车了

. importing ZLM's objects into ZLM
. importing ZLM's objects into ZLM
. . importing table                           "T1"     100710 rows imported
Import terminated successfully without warnings.
[oracle@ora10g ~]$ exit
exit

SQL> select count(*) from t1;

  COUNT(*)
----------
    100710

SQL> select count(*) from t2;
select count(*) from t2
                     *
ERROR at line 1:
ORA-00942: table or view does not exist

能够看到。仅仅有t1表是导入的。尽管之前导出的是t1,t2两张表到一个dmp文件,可是导入的时候,能够仅仅依照须要的内容单独导入,相当于取了一个子集

SQL> !
[oracle@ora10g ~]$ imp

Import: Release 10.2.0.1.0 - Production on 11 11:10:48 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Username: zlm
Password: 

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

Import file: expdat.dmp > t1_t2.dmp

Enter insert buffer size (minimum is 8192) 30720> 

Export file created by EXPORT:V10.02.01 via conventional path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
List contents of import file only (yes/no): no > 

Ignore create error due to object existence (yes/no): no > yes

Import grants (yes/no): yes > 

Import table data (yes/no): yes > 

Import entire export file (yes/no): no > yes

. importing ZLM's objects into ZLM
. importing ZLM's objects into ZLM
. . importing table                           "T1"     100710 rows imported
. . importing table                           "T2"          2 rows imported
Import terminated successfully without warnings.

这次直接选择了把整个导出文件的内容到导入到zlm用户,注意后面选项的不同之处

[oracle@ora10g ~]$ exit
exit

SQL> select count(*) from t1;

  COUNT(*)
----------
    201420

SQL> select count(*) from t2;

  COUNT(*)
----------
         2

如今t1,t2表都有数据了,不同的是,因为刚才用了ingore error的方式把t1表导出了2次,所以t1表中成了20W行

三、按用户导出导入測试

这是导入导出中用的最多的一种方式,因此在使用交互方式的时候。默认就是採用了这样的方式

SQL> !
[oracle@ora10g ~]$ exp

Export: Release 10.2.0.1.0 - Production on 11 11:11:42 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Username: zlm
Password: 

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Enter array fetch buffer size: 4096 > 8192

Export file: expdat.dmp > zlm.dmp

(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > --按用户导出是默认的方式。直接回车就可以

Export grants (yes/no): yes > 

Export table data (yes/no): yes > 

Compress extents (yes/no): yes > 

Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

About to export specified users ...
User to be exported: (RETURN to quit) > zlm

User to be exported: (RETURN to quit) >     --指定完须要导出的用户zlm后。直接回车退出配置模式。開始导出

. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user ZLM 
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user ZLM 
About to export ZLM's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export ZLM's tables via Conventional Path ...
. . exporting table                             T1     201420 rows exported
. . exporting table                             T2          2 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.
[oracle@ora10g ~]$ exit
exit

--删除源表。并删除用户zlm
SQL> select count(*) from t1;

  COUNT(*)
----------
    201420

SQL> select count(*) from t2;

  COUNT(*)
----------
         2

SQL> drop table t1 purge;

Table dropped.

SQL> drop table t2 purge;

Table dropped.

SQL> drop user zlm cascade;
drop user zlm cascade
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected


SQL> disc
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> conn /as sysdba
Connected.
SQL> drop user zlm cascade;

User dropped.

SQL> !
[oracle@ora10g ~]$ imp

Import: Release 10.2.0.1.0 - Production on 11 11:14:39 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Username: zlm
Password: 

IMP-00058: ORACLE error 1017 encountered    --因为zlm用户已经不存在。因此报错
ORA-01017: invalid username/password; logon deniedUsername: system    --以system用户登录运行导入
Password: 

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

Import file: expdat.dmp > zlm.dmp

Enter insert buffer size (minimum is 8192) 30720> 

Export file created by EXPORT:V10.02.01 via conventional path

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

import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
List contents of import file only (yes/no): no > 

Ignore create error due to object existence (yes/no): no > 

Import grants (yes/no): yes > 

Import table data (yes/no): yes > 

Import entire export file (yes/no): no > 
Username: zlm

Enter table(T) or partition(T:P) names. Null list means all tables for user
Enter table(T) or partition(T:P) name or . if done: 

. importing ZLM's objects into SYSTEM
. . importing table                           "T1"     201420 rows imported
IMP-00015: following statement failed because the object already exists:
 "CREATE TABLE "T2" ("OBJECT_NAME" VARCHAR2(128), "SUBOBJECT_NAME" VARCHAR2(3"
 "0), "OBJECT_ID" NUMBER, "DATA_OBJECT_ID" NUMBER, "OBJECT_TYPE" VARCHAR2(19)"
 ", "CREATED" DATE, "LAST_DDL_TIME" DATE, "TIMESTAMP" VARCHAR2(19), "STATUS" "
 "VARCHAR2(7), "TEMPORARY" VARCHAR2(1), "GENERATED" VARCHAR2(1), "SECONDARY" "
 "VARCHAR2(1))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL"
 " 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)                  "
 "LOGGING NOCOMPRESS"
Import terminated successfully with warnings.
[oracle@ora10g ~]$ exit
exit

尽管是依照用户的方式导出的,但导入之前,还是必需要有同样的用户存在。删除用户以后。是无法进行导入的

--又一次创建回zlm用户
SQL> create user zlm identified by zlm;

User created.

SQL> grant dba to zlm;

Grant succeeded.

SQL> select username,default_tablespace from dba_users where username='ZLM';

USERNAME                       DEFAULT_TABLESPACE
------------------------------ ------------------------------
ZLM                            USERS    --又一次创建用户后。没有专门指定缺省表空间,就使用整个数据库的缺省表空间USERS

SQL> !
[oracle@ora10g ~]$ imp

Import: Release 10.2.0.1.0 - Production on 11 11:17:40 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Username: zlm
Password: 

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

Import file: expdat.dmp > zlm.dmp

Enter insert buffer size (minimum is 8192) 30720> 

Export file created by EXPORT:V10.02.01 via conventional path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
List contents of import file only (yes/no): no > 

Ignore create error due to object existence (yes/no): no > 

Import grants (yes/no): yes > 

Import table data (yes/no): yes > 

Import entire export file (yes/no): no > 
Username: zlm

Enter table(T) or partition(T:P) names. Null list means all tables for user
Enter table(T) or partition(T:P) name or . if done: 

. importing ZLM's objects into ZLM
. . importing table                           "T1"     201420 rows imported
. . importing table                           "T2"          2 rows imported
Import terminated successfully without warnings.
[oracle@ora10g ~]$ exit
exit

导入成功了,zlm用户的全部对象都被导入了。即完毕了对用户的逻辑恢复

SQL> select count(*) from t1;
select count(*) from t1
                     *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> show user
USER is "SYS"
SQL> conn zlm/zlm
Connected.
SQL> select count(*) from t1;

  COUNT(*)
----------
    201420

SQL> select count(*) from t2;

  COUNT(*)
----------
         2

SQL>  select username,default_tablespace from dba_users where username='ZLM';

USERNAME                       DEFAULT_TABLESPACE
------------------------------ ------------------------------
ZLM                            USERS

SQL> set line 130
SQL> select owner,table_name,tablespace_name from dba_tables where owner='ZLM';

OWNER                          TABLE_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------ ------------------------------
ZLM                            T1                             ZLM
ZLM                            T2                             ZLM

虽然zlm用户的默认表空间是USERS。可是用imp导入后的表还是会去找原来的表空间进行恢复。即“ZLM”,那么我们把原来的表空间也删除掉,会怎么样呢?

--删除ZLM表空间后測试恢复情况
SQL> drop tablespace zlm including contents;

Tablespace dropped.

SQL> select ts#,name from v$tablespace;

       TS# NAME
---------- ------------------------------
         0 SYSTEM
         1 UNDOTBS1
         2 SYSAUX
         4 USERS
         6 EXAMPLE
         3 TEMP

6 rows selected.

SQL> col name for a45
SQL> select file#,name from v$datafile;

     FILE# NAME
---------- ---------------------------------------------
         1 /u01/app/oracle/oradata/ora10g/system01.dbf
         2 /u01/app/oracle/oradata/ora10g/undotbs01.dbf
         3 /u01/app/oracle/oradata/ora10g/sysaux01.dbf
         4 /u01/app/oracle/oradata/ora10g/users01.dbf
         5 /u01/app/oracle/oradata/ora10g/example01.dbf

注意。使用including contents仅仅是把可控制文件里对应的信息删除。物理上还是存在于OS的磁盘上的,假设要连同文件一起删除,那么就要使用including contents and datafiles。那么就连渣渣也不剩了

SQL> !
[oracle@ora10g ~]$ imp

Import: Release 10.2.0.1.0 - Production on 11 11:25:57 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Username: zlm
Password: 

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

Import file: expdat.dmp > zlm.dmp

Enter insert buffer size (minimum is 8192) 30720> 

Export file created by EXPORT:V10.02.01 via conventional path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
List contents of import file only (yes/no): no > 

Ignore create error due to object existence (yes/no): no > 

Import grants (yes/no): yes > 

Import table data (yes/no): yes > 

Import entire export file (yes/no): no > yes

. importing ZLM's objects into ZLM
. . importing table                           "T1"     201420 rows imported
. . importing table                           "T2"          2 rows imported
Import terminated successfully without warnings.
[oracle@ora10g ~]$ exit
exit

SQL> select count(*) from t1;

  COUNT(*)
----------
    201420

SQL> select count(*) from t2;

  COUNT(*)
----------
         2

SQL> select owner,table_name,tablespace_name from dba_tables where owner='ZLM';

OWNER                          TABLE_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------ ------------------------------
ZLM                            T2                             USERS
ZLM                            T1                             USERS

当我们把原来zlm用户导出时的表空间ZLM删除以后再倒入,此时会发现imp会把用户导到数据库缺省的USERS表空间上去,基于这样的原理,当我们做逻辑导入导出的时候。尽量保持源端与目标端有同样的环境,当然还包含字符集(这里没有做測试)等。否则在导入数据后。可能会产生意外地状况,例如说源库的表空间是非常大的。可是因为在目标库中没有创建对应的表空间,默认放到了USERS表空间中,环境和源库产生了不同,可能导入的时候就直接报错了。当然了,字符集更是一个要注意的问题。

四、按全库导出

全库导出非常easy。在选择导出对象的时候选择Entire Database就能够了

SQL> !
[oracle@ora10g ~]$ exp
 
Export: Release 10.2.0.1.0 - Production on 11 11:29:16 2014
 
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
 
 
Username: zlm
Password:
 
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Enter array fetch buffer size: 4096 > 8192
 
Export file: expdat.dmp > fulldb.dmp
 
(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > 1
 
Export grants (yes/no): yes >
 
Export table data (yes/no): yes >
 
Compress extents (yes/no): yes >
 
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
 
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions
. exporting system procedural objects and actions
. exporting pre-schema procedural objects and actions
. exporting cluster definitions
. about to export SYSTEM's tables via Conventional Path ...
. . exporting table                    DEF$_AQCALL          0 rows exported
. . exporting table                   DEF$_AQERROR          0 rows exported
. . exporting table                  DEF$_CALLDEST          0 rows exported
. . exporting table               DEF$_DEFAULTDEST          0 rows exported
. . exporting table               DEF$_DESTINATION          0 rows exported
. . exporting table                     DEF$_ERROR          0 rows exported
. . exporting table                       DEF$_LOB          0 rows exported
. . exporting table                    DEF$_ORIGIN          0 rows exported
. . exporting table                DEF$_PROPAGATOR          0 rows exported
. . exporting table       DEF$_PUSHED_TRANSACTIONS          0 rows exported
. . exporting table                  DEF$_TEMP$LOB          0 rows exported
. . exporting table       LOGSTDBY$APPLY_MILESTONE          0 rows exported
. . exporting table        LOGSTDBY$APPLY_PROGRESS
. . exporting partition                             P0          0 rows exported
. . exporting table                LOGSTDBY$EVENTS          0 rows exported
. . exporting table               LOGSTDBY$HISTORY          0 rows exported
. . exporting table            LOGSTDBY$PARAMETERS          0 rows exported
. . exporting table                 LOGSTDBY$PLSQL          0 rows exported
. . exporting table                   LOGSTDBY$SCN          0 rows exported
. . exporting table                  LOGSTDBY$SKIP          0 rows exported
. . exporting table      LOGSTDBY$SKIP_TRANSACTION          0 rows exported
. . exporting table               MVIEW$_ADV_INDEX          0 rows exported
. . exporting table                 MVIEW$_ADV_OWB
. . exporting table           MVIEW$_ADV_PARTITION          0 rows exported
. . exporting table                            OL$
. . exporting table                       OL$HINTS
. . exporting table                       OL$NODES
. . exporting table        REPCAT$_AUDIT_ATTRIBUTE          2 rows exported
. . exporting table           REPCAT$_AUDIT_COLUMN          0 rows exported
. . exporting table           REPCAT$_COLUMN_GROUP          0 rows exported
. . exporting table               REPCAT$_CONFLICT          0 rows exported
. . exporting table                    REPCAT$_DDL          0 rows exported
. . exporting table             REPCAT$_EXCEPTIONS          0 rows exported
. . exporting table              REPCAT$_EXTENSION          0 rows exported
. . exporting table                REPCAT$_FLAVORS          0 rows exported
. . exporting table         REPCAT$_FLAVOR_OBJECTS          0 rows exported
. . exporting table              REPCAT$_GENERATED          0 rows exported
. . exporting table         REPCAT$_GROUPED_COLUMN          0 rows exported
. . exporting table      REPCAT$_INSTANTIATION_DDL          0 rows exported
. . exporting table            REPCAT$_KEY_COLUMNS          0 rows exported
. . exporting table           REPCAT$_OBJECT_PARMS          0 rows exported
. . exporting table           REPCAT$_OBJECT_TYPES         28 rows exported
. . exporting table       REPCAT$_PARAMETER_COLUMN          0 rows exported
. . exporting table               REPCAT$_PRIORITY          0 rows exported
. . exporting table         REPCAT$_PRIORITY_GROUP          0 rows exported
. . exporting table      REPCAT$_REFRESH_TEMPLATES          0 rows exported
. . exporting table                 REPCAT$_REPCAT          0 rows exported
. . exporting table              REPCAT$_REPCATLOG          0 rows exported
. . exporting table              REPCAT$_REPCOLUMN          0 rows exported
. . exporting table         REPCAT$_REPGROUP_PRIVS          0 rows exported
. . exporting table              REPCAT$_REPOBJECT          0 rows exported
. . exporting table                REPCAT$_REPPROP          0 rows exported
. . exporting table              REPCAT$_REPSCHEMA          0 rows exported
. . exporting table             REPCAT$_RESOLUTION          0 rows exported
. . exporting table      REPCAT$_RESOLUTION_METHOD         19 rows exported
. . exporting table  REPCAT$_RESOLUTION_STATISTICS          0 rows exported
. . exporting table    REPCAT$_RESOL_STATS_CONTROL          0 rows exported
. . exporting table          REPCAT$_RUNTIME_PARMS          0 rows exported
. . exporting table              REPCAT$_SITES_NEW          0 rows exported
. . exporting table           REPCAT$_SITE_OBJECTS          0 rows exported
. . exporting table              REPCAT$_SNAPGROUP          0 rows exported
. . exporting table       REPCAT$_TEMPLATE_OBJECTS          0 rows exported
. . exporting table         REPCAT$_TEMPLATE_PARMS          0 rows exported
. . exporting table     REPCAT$_TEMPLATE_REFGROUPS          0 rows exported
. . exporting table         REPCAT$_TEMPLATE_SITES          0 rows exported
. . exporting table        REPCAT$_TEMPLATE_STATUS          3 rows exported
. . exporting table       REPCAT$_TEMPLATE_TARGETS          0 rows exported
. . exporting table         REPCAT$_TEMPLATE_TYPES          2 rows exported
. . exporting table    REPCAT$_USER_AUTHORIZATIONS          0 rows exported
. . exporting table       REPCAT$_USER_PARM_VALUES          0 rows exported
. . exporting table        SQLPLUS_PRODUCT_PROFILE          0 rows exported
. . exporting table             SYS_IMPORT_FULL_01       9449 rows exported
. . exporting table                             T2      50355 rows exported
. about to export OUTLN's tables via Conventional Path ...
. . exporting table                            OL$          0 rows exported
. . exporting table                       OL$HINTS          0 rows exported
. . exporting table                       OL$NODES          0 rows exported
. about to export TSMSYS's tables via Conventional Path ...
. . exporting table                           SRS$          0 rows exported
. about to export ANONYMOUS's tables via Conventional Path ...
. about to export OLAPSYS's tables via Conventional Path ...
. . exporting table                   CWM$ARGUMENT          0 rows exported
. . exporting table             CWM$CLASSIFICATION         42 rows exported
. . exporting table        CWM$CLASSIFICATIONENTRY         66 rows exported
. . exporting table         CWM$CLASSIFICATIONTYPE         15 rows exported
. . exporting table                       CWM$CUBE          2 rows exported
. . exporting table           CWM$CUBEDIMENSIONUSE          9 rows exported
. . exporting table                  CWM$DIMENSION          5 rows exported
. . exporting table         CWM$DIMENSIONATTRIBUTE         23 rows exported
. . exporting table                     CWM$DOMAIN         21 rows exported
. . exporting table             CWM$FACTLEVELGROUP          2 rows exported
. . exporting table               CWM$FACTLEVELUSE          9 rows exported
. . exporting table               CWM$FACTTABLEMAP          2 rows exported
. . exporting table                    CWM$FACTUSE          4 rows exported
. . exporting table                   CWM$FUNCTION         14 rows exported
. . exporting table                CWM$FUNCTIONUSE          4 rows exported
. . exporting table                  CWM$HIERARCHY          7 rows exported
. . exporting table                    CWM$ITEMMAP         59 rows exported
. . exporting table                    CWM$ITEMUSE        118 rows exported
. . exporting table                      CWM$LEVEL         27 rows exported
. . exporting table             CWM$LEVELATTRIBUTE         67 rows exported
. . exporting table                    CWM$MEASURE          4 rows exported
. . exporting table        CWM$MEASUREDIMENSIONUSE          4 rows exported
. . exporting table                      CWM$MODEL          3 rows exported
. . exporting table                 CWM$OBJECTTYPE         15 rows exported
. . exporting table                  CWM$PARAMETER          5 rows exported
. . exporting table                    CWM$PROJECT          3 rows exported
. . exporting table           CWM2$AWCOMPOSITESPEC          0 rows exported
. . exporting table      CWM2$AWCOMPSPECMEMBERSHIP          0 rows exported
. . exporting table                 CWM2$AWCUBEAGG          0 rows exported
. . exporting table            CWM2$AWCUBEAGGLEVEL          0 rows exported
. . exporting table          CWM2$AWCUBEAGGMEASURE          0 rows exported
. . exporting table            CWM2$AWCUBECOMPPLAN          0 rows exported
. . exporting table        CWM2$AWCUBECREATEACCESS
. . exporting table                CWM2$AWCUBELOAD          0 rows exported
. . exporting table         CWM2$AWCUBELOADAGGPLAN          0 rows exported
. . exporting table          CWM2$AWCUBELOADFILTER          0 rows exported
. . exporting table         CWM2$AWCUBELOADMEASURE          0 rows exported
. . exporting table            CWM2$AWCUBELOADPARM          1 rows exported
. . exporting table       CWM2$AWCUBELOADPARMVALUE          0 rows exported
. . exporting table            CWM2$AWCUBELOADTYPE          2 rows exported
. . exporting table         CWM2$AWDIMCREATEACCESS
. . exporting table                 CWM2$AWDIMLOAD          0 rows exported
. . exporting table           CWM2$AWDIMLOADFILTER          0 rows exported
. . exporting table             CWM2$AWDIMLOADPARM          4 rows exported
. . exporting table        CWM2$AWDIMLOADPARMVALUE          0 rows exported
. . exporting table             CWM2$AWDIMLOADTYPE          2 rows exported
. . exporting table                CWM2$AWVIEWCOLS          0 rows exported
. . exporting table                   CWM2$AWVIEWS          0 rows exported
. . exporting table           CWM2$AW_DIMENSIONMAP          0 rows exported
. . exporting table             CWM2$AW_MEASUREMAP          0 rows exported
. . exporting table   CWM2$CLASSIFICATIONVALUEPAIR          0 rows exported
. . exporting table                      CWM2$CUBE          0 rows exported
. . exporting table          CWM2$CUBEDIMENSIONUSE          0 rows exported
. . exporting table                 CWM2$DIMENSION          0 rows exported
. . exporting table        CWM2$DIMENSIONATTRIBUTE          0 rows exported
. . exporting table             CWM2$DIMHIERLVLMAP          0 rows exported
. . exporting table            CWM2$FACTDIMHIERMAP          0 rows exported
. . exporting table        CWM2$FACTDIMHIERTPLSDTL          0 rows exported
. . exporting table      CWM2$FACTKEYDIMHIERLVLMAP          0 rows exported
. . exporting table         CWM2$FACTKEYDIMHIERMAP          0 rows exported
. . exporting table                 CWM2$HIERARCHY          0 rows exported
. . exporting table            CWM2$HIERCUSTOMSORT          0 rows exported
. . exporting table              CWM2$HIERLEVELREL          0 rows exported
. . exporting table                     CWM2$LEVEL          0 rows exported
. . exporting table            CWM2$LEVELATTRIBUTE          0 rows exported
. . exporting table         CWM2$LEVELATTRIBUTEMAP          0 rows exported
. . exporting table                   CWM2$MEASURE          0 rows exported
. . exporting table           CWM2$MEASURETABLEMAP          0 rows exported
. . exporting table          CWM2$MRALL_AWVIEWCOLS          0 rows exported
. . exporting table             CWM2$MRALL_AWVIEWS          0 rows exported
. . exporting table            CWM2$MRALL_CATALOGS          0 rows exported
. . exporting table CWM2$MRALL_CATALOG_ENTITY_USES          0 rows exported
. . exporting table       CWM2$MRALL_CUBE_MEASURES          0 rows exported
. . exporting table          CWM2$MRALL_CWM1_AGGOP          0 rows exported
. . exporting table         CWM2$MRALL_CWM1_AGGORD          0 rows exported
. . exporting table         CWM2$MRALL_DESCRIPTORS         41 rows exported
. . exporting table      CWM2$MRALL_DIM_ATTRIBUTES          0 rows exported
. . exporting table           CWM2$MRALL_DIM_HIERS          0 rows exported
. . exporting table CWM2$MRALL_DIM_HIER_LEVEL_USES          0 rows exported
. . exporting table CWM2$MRALL_DIM_LEVEL_ATTR_MAPS          0 rows exported
. . exporting table    CWM2$MRALL_ENTITY_DESC_USES          0 rows exported
. . exporting table    CWM2$MRALL_ENTITY_EXT_PARMS          0 rows exported
. . exporting table   CWM2$MRALL_ENTITY_PARAMETERS          0 rows exported
. . exporting table      CWM2$MRALL_FACTTBLFCTMAPS          0 rows exported
. . exporting table      CWM2$MRALL_FACTTBLKEYMAPS          0 rows exported
. . exporting table            CWM2$MRALL_HIERDIMS          0 rows exported
. . exporting table  CWM2$MRALL_HIERDIM_KEYCOL_MAP          0 rows exported
. . exporting table    CWM2$MRALL_HIER_CUSTOM_SORT          0 rows exported
. . exporting table   CWM2$MRALL_JOIN_KEY_COL_USES          0 rows exported
. . exporting table            CWM2$MRALL_LISTDIMS          0 rows exported
. . exporting table      CWM2$MRALL_OLAP2_AGG_USES          0 rows exported
. . exporting table          CWM2$MRFACTTBLFCTMAPS          0 rows exported
. . exporting table          CWM2$MRFACTTBLKEYMAPS          0 rows exported
. . exporting table    CWM2$OLAPEXPORTCOMMANDTABLE
. . exporting table     CWM2$OLAPEXPORTOBJECTTABLE
. . exporting table          CWM2$OLAPMANAGERTABLE
. . exporting table         CWM2$OLAPVALIDATETABLE
. . exporting table          CWM2$STOREDDIMLVLTPLS          0 rows exported
. . exporting table       CWM2$STOREDDIMLVLTPLSDTL          0 rows exported
. . exporting table   CWM2$_AW_NEXT_PERM_CUST_MEAS          0 rows exported
. . exporting table   CWM2$_AW_NEXT_TEMP_CUST_MEAS
. . exporting table    CWM2$_AW_PERM_CUST_MEAS_MAP          0 rows exported
. . exporting table    CWM2$_AW_TEMP_CUST_MEAS_MAP
. . exporting table              CWM2$_TEMP_VALUES
. . exporting table               MRAC_OLAP2_AWS_T          0 rows exported
. . exporting table     MRAC_OLAP2_AW_ATTRIBUTES_T          0 rows exported
. . exporting table          MRAC_OLAP2_AW_CUBES_T          0 rows exported
. . exporting table   MRAC_OLAP2_AW_CUBE_AGG_LVL_T          0 rows exported
. . exporting table  MRAC_OLAP2_AW_CUBE_AGG_MEAS_T          0 rows exported
. . exporting table    MRAC_OLAP2_AW_CUBE_AGG_OP_T          0 rows exported
. . exporting table MRAC_OLAP2_AW_CUBE_AGG_SPECS_T          0 rows exported
. . exporting table  MRAC_OLAP2_AW_CUBE_DIM_USES_T          0 rows exported
. . exporting table  MRAC_OLAP2_AW_CUBE_MEASURES_T          0 rows exported
. . exporting table     MRAC_OLAP2_AW_DIMENSIONS_T          0 rows exported
. . exporting table     MRAC_OLAP2_AW_DIM_LEVELS_T          0 rows exported
. . exporting table   MRAC_OLAP2_AW_HIER_LVL_ORD_T          0 rows exported
. . exporting table   MRAC_OLAP2_AW_MAP_ATTR_USE_T          0 rows exported
. . exporting table    MRAC_OLAP2_AW_MAP_DIM_USE_T          0 rows exported
. . exporting table   MRAC_OLAP2_AW_MAP_MEAS_USE_T          0 rows exported
. . exporting table  MRAC_OLAP2_AW_PHYS_OBJ_PROP_T          0 rows exported
. . exporting table       MRAC_OLAP2_AW_PHYS_OBJ_T          0 rows exported
. . exporting table             OLAP_SESSION_CUBES
. . exporting table              OLAP_SESSION_DIMS
. . exporting table           OLAP_SESSION_OBJECTS
. . exporting table                   XML_LOAD_LOG          0 rows exported
. . exporting table               XML_LOAD_RECORDS          0 rows exported
. about to export MDDATA's tables via Conventional Path ...
. about to export SYSMAN's tables via Conventional Path ...
. . exporting table       AQ$_MGMT_NOTIFY_QTABLE_G          0 rows exported
. . exporting table       AQ$_MGMT_NOTIFY_QTABLE_H          0 rows exported
. . exporting table       AQ$_MGMT_NOTIFY_QTABLE_I          0 rows exported
. . exporting table       AQ$_MGMT_NOTIFY_QTABLE_S          3 rows exported
. . exporting table       AQ$_MGMT_NOTIFY_QTABLE_T          0 rows exported
. . exporting table                    EM_IPW_INFO          0 rows exported
. . exporting table                 ESM_COLLECTION         55 rows exported
. . exporting table            MGMT_ADMIN_LICENSES          5 rows exported
. . exporting table   MGMT_ADMIN_METRIC_THRESHOLDS          0 rows exported
. . exporting table            MGMT_AGENT_SEC_INFO          0 rows exported
. . exporting table                MGMT_ANNOTATION          0 rows exported
. . exporting table           MGMT_ARU_CREDENTIALS          0 rows exported
. . exporting table    MGMT_ARU_FAMILY_PRODUCT_MAP        579 rows exported
. . exporting table             MGMT_ARU_LANGUAGES         37 rows exported
. . exporting table        MGMT_ARU_OUI_COMPONENTS        319 rows exported
. . exporting table             MGMT_ARU_PLATFORMS         49 rows exported
. . exporting table              MGMT_ARU_PRODUCTS        524 rows exported
. . exporting table   MGMT_ARU_PRODUCT_RELEASE_MAP       2621 rows exported
. . exporting table              MGMT_ARU_RELEASES        301 rows exported
. . exporting table              MGMT_AVAILABILITY          5 rows exported
. . exporting table       MGMT_AVAILABILITY_MARKER          5 rows exported
. . exporting table      MGMT_BACKUP_CONFIGURATION          1 rows exported
. . exporting table             MGMT_BCN_AVAIL_DEF          0 rows exported
. . exporting table             MGMT_BCN_AVAIL_JOB          0 rows exported
. . exporting table             MGMT_BCN_AVAIL_LOG          0 rows exported
. . exporting table                MGMT_BCN_TARGET          0 rows exported
. . exporting table           MGMT_BCN_TARGET_LOCK          0 rows exported
. . exporting table            MGMT_BCN_TARGET_TXN          0 rows exported
. . exporting table              MGMT_BCN_TXN_DEFN          0 rows exported
. . exporting table              MGMT_BCN_TXN_HTTP          0 rows exported
. . exporting table        MGMT_BCN_TXN_HTTP_PARAM          0 rows exported
. . exporting table              MGMT_BCN_TXN_PING          0 rows exported
. . exporting table                 MGMT_BLACKOUTS          0 rows exported
. . exporting table     MGMT_BLACKOUT_FLAT_TARGETS          0 rows exported
. . exporting table          MGMT_BLACKOUT_HISTORY          0 rows exported
. . exporting table    MGMT_BLACKOUT_PROXY_TARGETS          5 rows exported
. . exporting table           MGMT_BLACKOUT_REASON          1 rows exported
. . exporting table         MGMT_BLACKOUT_SCHEDULE          0 rows exported
. . exporting table            MGMT_BLACKOUT_STATE          0 rows exported
. . exporting table   MGMT_BLACKOUT_TARGET_DETAILS          0 rows exported
. . exporting table          MGMT_BLACKOUT_WINDOWS          0 rows exported
. . exporting table              MGMT_BUG_ADVISORY          0 rows exported
. . exporting table          MGMT_BUG_ADVISORY_BUG          0 rows exported
. . exporting table        MGMT_BUG_ADV_HOME_PATCH          0 rows exported
. . exporting table       MGMT_BUG_AVAILABLE_PATCH          0 rows exported
. . exporting table   MGMT_BUG_FIX_APPLICABLE_COMP          0 rows exported
. . exporting table  MGMT_BUG_FIX_APPLIC_COMP_LIST          0 rows exported
. . exporting table       MGMT_BUG_PATCH_FIXES_BUG          0 rows exported
. . exporting table        MGMT_BUG_PATCH_PLATFORM          0 rows exported
. . exporting table          MGMT_CHANGE_AGENT_URL          0 rows exported
. . exporting table    MGMT_COLLECTION_CREDENTIALS          0 rows exported
. . exporting table     MGMT_COLLECTION_PROPERTIES          4 rows exported
. . exporting table    MGMT_COMP_RESULT_TO_JOB_MAP          0 rows exported
. . exporting table           MGMT_COMP_TARGET_DEF          0 rows exported
. . exporting table     MGMT_CONTAINER_CREDENTIALS          0 rows exported
. . exporting table             MGMT_CREATED_USERS          4 rows exported
. . exporting table               MGMT_CREDENTIALS          0 rows exported
. . exporting table              MGMT_CREDENTIALS2          0 rows exported
. . exporting table           MGMT_CREDENTIAL_SETS          0 rows exported
. . exporting table    MGMT_CREDENTIAL_SET_COLUMNS          0 rows exported
. . exporting table          MGMT_CREDENTIAL_TYPES          0 rows exported
. . exporting table   MGMT_CREDENTIAL_TYPE_COLUMNS          0 rows exported
. . exporting table  MGMT_CREDENTIAL_TYPE_COL_VALS          0 rows exported
. . exporting table       MGMT_CREDENTIAL_TYPE_REF          0 rows exported
. . exporting table      MGMT_CURRENT_AVAILABILITY          5 rows exported
. . exporting table           MGMT_CURRENT_METRICS        656 rows exported
. . exporting table     MGMT_CURRENT_METRIC_ERRORS          2 rows exported
. . exporting table          MGMT_CURRENT_SEVERITY          6 rows exported
. . exporting table          MGMT_DBNET_TNS_ADMINS          0 rows exported
. . exporting table       MGMT_DB_CONTROLFILES_ECM          6 rows exported
. . exporting table          MGMT_DB_DATAFILES_ECM         14 rows exported
. . exporting table    MGMT_DB_DBNINSTANCEINFO_ECM          2 rows exported
. . exporting table           MGMT_DB_FEATUREUSAGE         62 rows exported
. . exporting table      MGMT_DB_HDM_METRIC_HELPER          1 rows exported
. . exporting table        MGMT_DB_INIT_PARAMS_ECM        518 rows exported
. . exporting table            MGMT_DB_INVOBJS_ECM          0 rows exported
. . exporting table    MGMT_DB_LATEST_HDM_FINDINGS          2 rows exported
. . exporting table            MGMT_DB_LICENSE_ECM          2 rows exported
. . exporting table MGMT_DB_RECSEGMENTSETTINGS_ECM          0 rows exported
. . exporting table      MGMT_DB_RECTSSETTINGS_ECM          2 rows exported
. . exporting table    MGMT_DB_RECUSERSETTINGS_ECM          0 rows exported
. . exporting table           MGMT_DB_REDOLOGS_ECM          6 rows exported
. . exporting table      MGMT_DB_ROLLBACK_SEGS_ECM          2 rows exported
. . exporting table                MGMT_DB_SGA_ECM         18 rows exported
. . exporting table        MGMT_DB_TABLESPACES_ECM         14 rows exported
. . exporting table   MGMT_DELTA_COMPARISON_DELTAS          0 rows exported
. . exporting table  MGMT_DELTA_COMP_DELTA_DETAILS          0 rows exported
. . exporting table       MGMT_DELTA_COMP_KEY_COLS          0 rows exported
. . exporting table     MGMT_DELTA_COMP_PROPERTIES          0 rows exported
. . exporting table      MGMT_DELTA_COMP_SUMMARIES          0 rows exported
. . exporting table      MGMT_DELTA_SUMMARY_ERRORS          0 rows exported
. . exporting table               MGMT_DELTA_ENTRY         34 rows exported
. . exporting table        MGMT_DELTA_ENTRY_VALUES         15 rows exported
. . exporting table                 MGMT_DELTA_IDS         22 rows exported
. . exporting table           MGMT_DELTA_ID_VALUES         68 rows exported
. . exporting table    MGMT_DELTA_SAVED_COMPARISON          0 rows exported
. . exporting table                MGMT_DELTA_SNAP         22 rows exported
. . exporting table      MGMT_DIROBJ_USERS_HOTLIST          0 rows exported
. . exporting table         MGMT_DUPLICATE_TARGETS          0 rows exported
. . exporting table               MGMT_E2E_DETAILS          0 rows exported
. . exporting table          MGMT_E2E_DETAILS_1DAY          0 rows exported
. . exporting table         MGMT_E2E_DETAILS_1HOUR          0 rows exported
. . exporting table                  MGMT_E2E_JDBC          0 rows exported
. . exporting table             MGMT_E2E_JDBC_1DAY          0 rows exported
. . exporting table            MGMT_E2E_JDBC_1HOUR          0 rows exported
. . exporting table                   MGMT_E2E_SQL          0 rows exported
. . exporting table              MGMT_E2E_SQL_1DAY          0 rows exported
. . exporting table             MGMT_E2E_SQL_1HOUR          0 rows exported
. . exporting table              MGMT_E2E_SQL_CONN          0 rows exported
. . exporting table              MGMT_E2E_SQL_STMT          0 rows exported
. . exporting table               MGMT_E2E_SUMMARY          0 rows exported
. . exporting table          MGMT_E2E_SUMMARY_1DAY          0 rows exported
. . exporting table         MGMT_E2E_SUMMARY_1HOUR          0 rows exported
. . exporting table               MGMT_ECM_ARU_MAP         22 rows exported
. . exporting table                   MGMT_ECM_CSA          0 rows exported
. . exporting table           MGMT_ECM_CSA_COOKIES          0 rows exported
. . exporting table            MGMT_ECM_CSA_CUSTOM          0 rows exported
. . exporting table      MGMT_ECM_CSA_GENERAL_INFO          0 rows exported
. . exporting table     MGMT_ECM_CSA_SNAPSHOT_INFO          0 rows exported
. . exporting table          MGMT_ECM_GEN_SNAPSHOT         14 rows exported
. . exporting table   MGMT_ECM_HOST_CONFIGS_TO_DEL          0 rows exported
. . exporting table                    MGMT_ECM_HW          0 rows exported
. . exporting table                MGMT_ECM_HW_CPU          0 rows exported
. . exporting table             MGMT_ECM_HW_IOCARD          0 rows exported
. . exporting table                MGMT_ECM_HW_NIC          0 rows exported
. . exporting table          MGMT_ECM_LOADED_FILES          0 rows exported
. . exporting table                    MGMT_ECM_OS          0 rows exported
. . exporting table          MGMT_ECM_OS_COMPONENT          0 rows exported
. . exporting table         MGMT_ECM_OS_FILESYSTEM          0 rows exported
. . exporting table           MGMT_ECM_OS_PROPERTY          0 rows exported
. . exporting table      MGMT_ECM_OS_REGISTERED_SW          0 rows exported
. . exporting table MGMT_ECM_OS_REGISTERED_SW_COMP          0 rows exported
. . exporting table           MGMT_ECM_PATCH_CACHE          0 rows exported
. . exporting table             MGMT_ECM_RESOURCES         14 rows exported
. . exporting table              MGMT_ECM_SNAPSHOT          1 rows exported
. . exporting table   MGMT_ECM_SNAPSHOT_MD_COLUMNS        506 rows exported
. . exporting table    MGMT_ECM_SNAPSHOT_MD_TABLES         77 rows exported
. . exporting table     MGMT_ECM_SNAPSHOT_METADATA         34 rows exported
. . exporting table   MGMT_ECM_SNAP_COMPONENT_INFO          4 rows exported
. . exporting table             MGMT_EMCRYPTO_SEED          1 rows exported
. . exporting table                  MGMT_EMD_PING          1 rows exported
. . exporting table    MGMT_ENTERPRISE_CREDENTIALS          0 rows exported
. . exporting table        MGMT_FAILOVER_CALLBACKS          2 rows exported
. . exporting table            MGMT_FAILOVER_TABLE          0 rows exported
. . exporting table   MGMT_FLAT_TARGET_MEMBERSHIPS          0 rows exported
. . exporting table                 MGMT_HA_BACKUP          1 rows exported
. . exporting table          MGMT_HA_CLS_INTR_CONN          0 rows exported
. . exporting table              MGMT_HA_FILES_ECM          0 rows exported
. . exporting table               MGMT_HA_INFO_ECM          2 rows exported
. . exporting table        MGMT_HA_INIT_PARAMS_ECM          0 rows exported
. . exporting table                   MGMT_HA_MTTR          1 rows exported
. . exporting table          MGMT_HA_RAC_INTR_CONN          0 rows exported
. . exporting table        MGMT_HA_RMAN_CONFIG_ECM          4 rows exported
. . exporting table            MGMT_HC_CPU_DETAILS          1 rows exported
. . exporting table       MGMT_HC_FS_MOUNT_DETAILS          3 rows exported
. . exporting table        MGMT_HC_HARDWARE_MASTER          1 rows exported
. . exporting table         MGMT_HC_IOCARD_DETAILS          0 rows exported
. . exporting table            MGMT_HC_NIC_DETAILS          0 rows exported
. . exporting table          MGMT_HC_OS_COMPONENTS        989 rows exported
. . exporting table          MGMT_HC_OS_PROPERTIES        514 rows exported
. . exporting table             MGMT_HC_OS_SUMMARY          1 rows exported
. . exporting table         MGMT_HC_SYSTEM_SUMMARY          1 rows exported
. . exporting table   MGMT_HC_VENDOR_SW_COMPONENTS        989 rows exported
. . exporting table      MGMT_HC_VENDOR_SW_SUMMARY        989 rows exported
. . exporting table          MGMT_HOST_CREDENTIALS          0 rows exported
. . exporting table               MGMT_INDEX_SIZES          0 rows exported
. . exporting table             MGMT_INV_COMPONENT        107 rows exported
. . exporting table       MGMT_INV_COMPONENT_PATCH          0 rows exported
. . exporting table             MGMT_INV_CONTAINER          2 rows exported
. . exporting table    MGMT_INV_CONTAINER_PROPERTY          0 rows exported
. . exporting table       MGMT_INV_DEPENDENCY_RULE        218 rows exported
. . exporting table                  MGMT_INV_FILE          0 rows exported
. . exporting table                 MGMT_INV_PATCH          0 rows exported
. . exporting table          MGMT_INV_PATCHED_FILE          0 rows exported
. . exporting table     MGMT_INV_PATCHED_FILE_COMP          0 rows exported
. . exporting table              MGMT_INV_PATCHSET          0 rows exported
. . exporting table       MGMT_INV_PATCH_FIXED_BUG          0 rows exported
. . exporting table       MGMT_INV_VERSIONED_PATCH          0 rows exported
. . exporting table                       MGMT_JOB          1 rows exported
. . exporting table        MGMT_JOB_BLACKOUT_ASSOC          0 rows exported
. . exporting table             MGMT_JOB_CALLBACKS          0 rows exported
. . exporting table               MGMT_JOB_COMMAND         30 rows exported
. . exporting table           MGMT_JOB_CREDENTIALS          0 rows exported
. . exporting table           MGMT_JOB_CRED_PARAMS         18 rows exported
. . exporting table      MGMT_JOB_EMD_STATUS_QUEUE          0 rows exported
. . exporting table                 MGMT_JOB_EVENT          1 rows exported
. . exporting table              MGMT_JOB_EXECPLAN        366 rows exported
. . exporting table             MGMT_JOB_EXECUTION          3 rows exported
. . exporting table     MGMT_JOB_EXEC_EVENT_PARAMS          0 rows exported
. . exporting table            MGMT_JOB_EXEC_LOCKS          0 rows exported
. . exporting table          MGMT_JOB_EXEC_SUMMARY          3 rows exported
. . exporting table           MGMT_JOB_EXT_TARGETS          0 rows exported
. . exporting table          MGMT_JOB_FLAT_TARGETS          0 rows exported
. . exporting table               MGMT_JOB_HISTORY          9 rows exported
. . exporting table          MGMT_JOB_LARGE_PARAMS          0 rows exported
. . exporting table             MGMT_JOB_LOCK_INFO          0 rows exported
. . exporting table          MGMT_JOB_LOCK_TARGETS          0 rows exported
. . exporting table    MGMT_JOB_NESTED_JOB_TARGETS          4 rows exported
. . exporting table                MGMT_JOB_OUTPUT          2 rows exported
. . exporting table             MGMT_JOB_PARAMETER          0 rows exported
. . exporting table          MGMT_JOB_PARAM_SOURCE        140 rows exported
. . exporting table           MGMT_JOB_PROP_PARAMS         12 rows exported
. . exporting table        MGMT_JOB_PURGE_CRITERIA          1 rows exported
. . exporting table        MGMT_JOB_PURGE_POLICIES          2 rows exported
. . exporting table         MGMT_JOB_PURGE_TARGETS          0 rows exported
. . exporting table          MGMT_JOB_PURGE_VALUES          1 rows exported
. . exporting table                MGMT_JOB_QUEUES          0 rows exported
. . exporting table              MGMT_JOB_SCHEDULE          2 rows exported
. . exporting table              MGMT_JOB_SEC_INFO          4 rows exported
. . exporting table   MGMT_JOB_SINGLE_TARGET_TYPES          7 rows exported
. . exporting table            MGMT_JOB_SQL_PARAMS          3 rows exported
. . exporting table      MGMT_JOB_STEP_COMMAND_LOG          0 rows exported
. . exporting table           MGMT_JOB_STEP_PARAMS       1128 rows exported
. . exporting table          MGMT_JOB_STEP_TARGETS          0 rows exported
. . exporting table          MGMT_JOB_SUBST_PARAMS          3 rows exported
. . exporting table                MGMT_JOB_TARGET          0 rows exported
. . exporting table     MGMT_JOB_TYPE_DISPLAY_INFO         31 rows exported
. . exporting table    MGMT_JOB_TYPE_DISPLAY_PARAM        172 rows exported
. . exporting table             MGMT_JOB_TYPE_INFO         53 rows exported
. . exporting table         MGMT_JOB_TYPE_URI_INFO         61 rows exported
. . exporting table           MGMT_JOB_USER_PARAMS          1 rows exported
. . exporting table          MGMT_JOB_VALUE_PARAMS         23 rows exported
. . exporting table               PARAM_VALUES_TAB         44 rows exported
. . exporting table   MGMT_LICENSABLE_TARGET_TYPES         11 rows exported
. . exporting table                  MGMT_LICENSES          2 rows exported
. . exporting table       MGMT_LICENSE_DEFINITIONS          5 rows exported
. . exporting table          MGMT_LOGIN_ASSISTANTS          2 rows exported
. . exporting table                 MGMT_LONG_TEXT          0 rows exported
. . exporting table              MGMT_MASTER_AGENT          0 rows exported
. . exporting table   MGMT_MASTER_CHANGED_CALLBACK          1 rows exported
. . exporting table             MGMT_METADATA_SETS          0 rows exported
. . exporting table                   MGMT_METRICS        136 rows exported
. . exporting table              MGMT_METRICS_1DAY        383 rows exported
. . exporting table             MGMT_METRICS_1HOUR       1131 rows exported
. . exporting table    MGMT_METRICS_COMPOSITE_KEYS          0 rows exported
. . exporting table               MGMT_METRICS_EXT         20 rows exported
. . exporting table               MGMT_METRICS_RAW       6361 rows exported
. . exporting table        MGMT_METRIC_COLLECTIONS         80 rows exported
. . exporting table    MGMT_METRIC_COLLECTIONS_REP          9 rows exported
. . exporting table         MGMT_METRIC_DEPENDENCY          0 rows exported
. . exporting table     MGMT_METRIC_DEPENDENCY_DEF         13 rows exported
. . exporting table MGMT_METRIC_DEPENDENCY_DETAILS          0 rows exported
. . exporting table             MGMT_METRIC_ERRORS         32 rows exported
. . exporting table         MGMT_METRIC_THRESHOLDS        189 rows exported
. . exporting table          MGMT_NOTIFICATION_LOG          0 rows exported
. . exporting table            MGMT_NOTIFY_DEVICES          0 rows exported
. . exporting table      MGMT_NOTIFY_DEVICE_PARAMS          0 rows exported
. . exporting table      MGMT_NOTIFY_DEV_SCHEDULES          0 rows exported
. . exporting table      MGMT_NOTIFY_EMAIL_GATEWAY          0 rows exported
. . exporting table          MGMT_NOTIFY_NOTIFYEES          0 rows exported
. . exporting table           MGMT_NOTIFY_PROFILES          3 rows exported
. . exporting table             MGMT_NOTIFY_QTABLE          0 rows exported
. . exporting table             MGMT_NOTIFY_QUEUES         24 rows exported
. . exporting table            MGMT_NOTIFY_REQUEUE          0 rows exported
. . exporting table              MGMT_NOTIFY_RULES          6 rows exported
. . exporting table       MGMT_NOTIFY_RULE_CONFIGS         30 rows exported
. . exporting table          MGMT_NOTIFY_SCHEDULES          0 rows exported
. . exporting table        MGMT_OB_ADMIN_CLIENT_DB          0 rows exported
. . exporting table            MGMT_OB_ADMIN_HOSTS          0 rows exported
. . exporting table            MGMT_OMS_PARAMETERS          7 rows exported
. . exporting table        MGMT_OSM_DISK_GROUP_ECM          0 rows exported
. . exporting table                MGMT_PARAMETERS          6 rows exported
. . exporting table         MGMT_PERFORMANCE_NAMES         43 rows exported
. . exporting table       MGMT_PLANPROBLEM_FACTORS          0 rows exported
. . exporting table             MGMT_POLICY_ERRORS          0 rows exported
. . exporting table              MGMT_POLICY_GROUP          6 rows exported
. . exporting table             MGMT_POLICY_PARAMS          0 rows exported
. . exporting table               MGMT_POLICY_RULE         55 rows exported
. . exporting table      MGMT_POLICY_RULE_CRITERIA          7 rows exported
. . exporting table   MGMT_POLICY_RULE_DEF_COLUMNS        111 rows exported
. . exporting table    MGMT_POLICY_RULE_DEF_PARAMS          0 rows exported
. . exporting table  MGMT_POLICY_SNAPSHOT_CRITERIA         18 rows exported
. . exporting table    MGMT_POLICY_TARGET_CRITERIA          9 rows exported
. . exporting table         MGMT_POLICY_VIOLATIONS         11 rows exported
. . exporting table     MGMT_POLICY_VIOLATION_ROWS         24 rows exported
. . exporting table   MGMT_POLICY_VIOLATION_VALUES         52 rows exported
. . exporting table  MGMT_PORTLET_PREFERENCE_STORE          0 rows exported
. . exporting table                     MGMT_PRIVS         19 rows exported
. . exporting table               MGMT_PRIV_GRANTS         10 rows exported
. . exporting table             MGMT_PRIV_INCLUDES         12 rows exported
. . exporting table              MGMT_PURGE_POLICY         12 rows exported
. . exporting table        MGMT_PURGE_POLICY_GROUP          7 rows exported
. . exporting table MGMT_PURGE_POLICY_TARGET_STATE         44 rows exported
. . exporting table             MGMT_RCVCAT_CONFIG          0 rows exported
. . exporting table              MGMT_RCVCAT_REPOS          0 rows exported
. . exporting table           MGMT_REBUILD_INDEXES          1 rows exported
. . exporting table                     MGMT_ROLES          1 rows exported
. . exporting table               MGMT_ROLE_GRANTS          1 rows exported
. . exporting table                  MGMT_SEC_INFO          1 rows exported
. . exporting table                  MGMT_SEVERITY        802 rows exported
. . exporting table             MGMT_SPACE_METRICS          2 rows exported
. . exporting table        MGMT_SQLPROBLEM_FACTORS          0 rows exported
. . exporting table             MGMT_SQL_BIND_VARS          0 rows exported
. . exporting table            MGMT_SQL_EVALUATION          0 rows exported
. . exporting table         MGMT_SQL_METRIC_HELPER          0 rows exported
. . exporting table                  MGMT_SQL_PLAN          0 rows exported
. . exporting table                 MGMT_SQL_REUSE          0 rows exported
. . exporting table               MGMT_SQL_SUMMARY          0 rows exported
. . exporting table     MGMT_STRING_METRIC_HISTORY        915 rows exported
. . exporting table          MGMT_SYSTEM_ERROR_LOG         16 rows exported
. . exporting table    MGMT_SYSTEM_PERFORMANCE_LOG        112 rows exported
. . exporting table               MGMT_TABLE_SIZES          0 rows exported
. . exporting table                   MGMT_TARGETS          5 rows exported
. . exporting table            MGMT_TARGETS_DELETE          0 rows exported
. . exporting table      MGMT_TARGET_ADD_CALLBACKS          1 rows exported
. . exporting table        MGMT_TARGET_AGENT_ASSOC          0 rows exported
. . exporting table              MGMT_TARGET_ASSOC          0 rows exported
. . exporting table     MGMT_TARGET_ASSOC_INSTANCE          0 rows exported
. . exporting table          MGMT_TARGET_BASELINES          0 rows exported
. . exporting table     MGMT_TARGET_BASELINES_DATA          0 rows exported
. . exporting table        MGMT_TARGET_CREDENTIALS          1 rows exported
. . exporting table   MGMT_TARGET_DELETE_CALLBACKS          7 rows exported
. . exporting table  MGMT_TARGET_DELETE_EXCEPTIONS          8 rows exported
. . exporting table        MGMT_TARGET_MEMBERSHIPS          0 rows exported
. . exporting table         MGMT_TARGET_PROPERTIES         45 rows exported
. . exporting table          MGMT_TARGET_PROP_DEFS          0 rows exported
. . exporting table       MGMT_TARGET_ROLLUP_TIMES        110 rows exported
. . exporting table              MGMT_TARGET_TYPES         23 rows exported
. . exporting table MGMT_TARGET_TYPE_COMPONENT_MAP          4 rows exported
. . exporting table           MGMT_TYPE_PROPERTIES         26 rows exported
. . exporting table   MGMT_UPDATE_CREDENTIALS_DATA          0 rows exported
. . exporting table         MGMT_UPDATE_OPERATIONS          0 rows exported
. . exporting table    MGMT_UPDATE_OPERATIONS_DATA          0 rows exported
. . exporting table MGMT_UPDATE_OPERATIONS_DETAILS          0 rows exported
. . exporting table    MGMT_UPDATE_PROPERTIES_DATA          0 rows exported
. . exporting table    MGMT_UPDATE_THRESHOLDS_DATA          0 rows exported
. . exporting table            MGMT_USER_CALLBACKS          4 rows exported
. . exporting table              MGMT_USER_CONTEXT          4 rows exported
. . exporting table              MGMT_USER_FOLDERS         18 rows exported
. . exporting table                 MGMT_USER_JOBS          1 rows exported
. . exporting table          MGMT_USER_PREFERENCES          0 rows exported
. . exporting table              MGMT_USER_TARGETS          0 rows exported
. . exporting table    MGMT_USER_TYPE_METRIC_PREFS          7 rows exported
. . exporting table                  MGMT_VERSIONS          2 rows exported
. . exporting table     MGMT_VIEW_USER_CREDENTIALS          1 rows exported
. about to export MGMT_VIEW's tables via Conventional Path ...
. about to export SCOTT's tables via Conventional Path ...
. . exporting table                          BONUS          0 rows exported
. . exporting table                           DEPT          4 rows exported
. . exporting table                            EMP         14 rows exported
. . exporting table                       SALGRADE          5 rows exported
. about to export HR's tables via Conventional Path ...
. . exporting table                      COUNTRIES         25 rows exported
. . exporting table                    DEPARTMENTS         27 rows exported
. . exporting table                      EMPLOYEES        107 rows exported
. . exporting table                           JOBS         19 rows exported
. . exporting table                    JOB_HISTORY         10 rows exported
. . exporting table                      LOCATIONS         23 rows exported
. . exporting table                        REGIONS          4 rows exported
. about to export OE's tables via Conventional Path ...
. . exporting table                 CATEGORIES_TAB         22 rows exported
. . exporting table     PRODUCT_REF_LIST_NESTEDTAB        288 rows exported
. . exporting table SUBCATEGORY_REF_LIST_NESTEDTAB         21 rows exported
. . exporting table                      CUSTOMERS        319 rows exported
. . exporting table                    INVENTORIES       1112 rows exported
. . exporting table                         ORDERS        105 rows exported
. . exporting table                    ORDER_ITEMS        665 rows exported
. . exporting table           PRODUCT_DESCRIPTIONS       8640 rows exported
. . exporting table            PRODUCT_INFORMATION        288 rows exported
. . exporting table                     PROMOTIONS          2 rows exported
EXP-00079: Data in table "PURCHASEORDER" is protected. Conventional path may only be exporting partial table.
. . exporting table                  PURCHASEORDER        132 rows exported
. . exporting table                     WAREHOUSES          9 rows exported
. about to export IX's tables via Conventional Path ...
. . exporting table        AQ$_ORDERS_QUEUETABLE_G          0 rows exported
. . exporting table        AQ$_ORDERS_QUEUETABLE_H          0 rows exported
. . exporting table        AQ$_ORDERS_QUEUETABLE_I          0 rows exported
. . exporting table        AQ$_ORDERS_QUEUETABLE_S          5 rows exported
. . exporting table        AQ$_ORDERS_QUEUETABLE_T          0 rows exported
. . exporting table      AQ$_STREAMS_QUEUE_TABLE_C          0 rows exported
. . exporting table      AQ$_STREAMS_QUEUE_TABLE_G          0 rows exported
. . exporting table      AQ$_STREAMS_QUEUE_TABLE_H          0 rows exported
. . exporting table      AQ$_STREAMS_QUEUE_TABLE_I          0 rows exported
. . exporting table      AQ$_STREAMS_QUEUE_TABLE_S          3 rows exported
. . exporting table      AQ$_STREAMS_QUEUE_TABLE_T          0 rows exported
. . exporting table              ORDERS_QUEUETABLE          0 rows exported
. . exporting table            STREAMS_QUEUE_TABLE          0 rows exported
. about to export SH's tables via Conventional Path ...
. . exporting table             CAL_MONTH_SALES_MV         48 rows exported
. . exporting table                       CHANNELS          5 rows exported
. . exporting table                          COSTS
. . exporting partition                     COSTS_1995          0 rows exported
. . exporting partition                     COSTS_1996          0 rows exported
. . exporting partition                  COSTS_H1_1997          0 rows exported
. . exporting partition                  COSTS_H2_1997          0 rows exported
. . exporting partition                  COSTS_Q1_1998       4411 rows exported
. . exporting partition                  COSTS_Q2_1998       2397 rows exported
. . exporting partition                  COSTS_Q3_1998       4129 rows exported
. . exporting partition                  COSTS_Q4_1998       4577 rows exported
. . exporting partition                  COSTS_Q1_1999       5884 rows exported
. . exporting partition                  COSTS_Q2_1999       4179 rows exported
. . exporting partition                  COSTS_Q3_1999       4336 rows exported
. . exporting partition                  COSTS_Q4_1999       5060 rows exported
. . exporting partition                  COSTS_Q1_2000       3772 rows exported
. . exporting partition                  COSTS_Q2_2000       3715 rows exported
. . exporting partition                  COSTS_Q3_2000       4798 rows exported
. . exporting partition                  COSTS_Q4_2000       5088 rows exported
. . exporting partition                  COSTS_Q1_2001       7328 rows exported
. . exporting partition                  COSTS_Q2_2001       5882 rows exported
. . exporting partition                  COSTS_Q3_2001       7545 rows exported
. . exporting partition                  COSTS_Q4_2001       9011 rows exported
. . exporting partition                  COSTS_Q1_2002          0 rows exported
. . exporting partition                  COSTS_Q2_2002          0 rows exported
. . exporting partition                  COSTS_Q3_2002          0 rows exported
. . exporting partition                  COSTS_Q4_2002          0 rows exported
. . exporting partition                  COSTS_Q1_2003          0 rows exported
. . exporting partition                  COSTS_Q2_2003          0 rows exported
. . exporting partition                  COSTS_Q3_2003          0 rows exported
. . exporting partition                  COSTS_Q4_2003          0 rows exported
. . exporting table                      COUNTRIES         23 rows exported
. . exporting table                      CUSTOMERS      55500 rows exported
. . exporting table           FWEEK_PSCAT_SALES_MV      11266 rows exported
. . exporting table              MVIEW$_EXCEPTIONS          0 rows exported
. . exporting table                       PRODUCTS         72 rows exported
. . exporting table                     PROMOTIONS        503 rows exported
. . exporting table                          SALES
. . exporting partition                     SALES_1995          0 rows exported
. . exporting partition                     SALES_1996          0 rows exported
. . exporting partition                  SALES_H1_1997          0 rows exported
. . exporting partition                  SALES_H2_1997          0 rows exported
. . exporting partition                  SALES_Q1_1998      43687 rows exported
. . exporting partition                  SALES_Q2_1998      35758 rows exported
. . exporting partition                  SALES_Q3_1998      50515 rows exported
. . exporting partition                  SALES_Q4_1998      48874 rows exported
. . exporting partition                  SALES_Q1_1999      64186 rows exported
. . exporting partition                  SALES_Q2_1999      54233 rows exported
. . exporting partition                  SALES_Q3_1999      67138 rows exported
. . exporting partition                  SALES_Q4_1999      62388 rows exported
. . exporting partition                  SALES_Q1_2000      62197 rows exported
. . exporting partition                  SALES_Q2_2000      55515 rows exported
. . exporting partition                  SALES_Q3_2000      58950 rows exported
. . exporting partition                  SALES_Q4_2000      55984 rows exported
. . exporting partition                  SALES_Q1_2001      60608 rows exported
. . exporting partition                  SALES_Q2_2001      63292 rows exported
. . exporting partition                  SALES_Q3_2001      65769 rows exported
. . exporting partition                  SALES_Q4_2001      69749 rows exported
. . exporting partition                  SALES_Q1_2002          0 rows exported
. . exporting partition                  SALES_Q2_2002          0 rows exported
. . exporting partition                  SALES_Q3_2002          0 rows exported
. . exporting partition                  SALES_Q4_2002          0 rows exported
. . exporting partition                  SALES_Q1_2003          0 rows exported
. . exporting partition                  SALES_Q2_2003          0 rows exported
. . exporting partition                  SALES_Q3_2003          0 rows exported
. . exporting partition                  SALES_Q4_2003          0 rows exported
. . exporting table         SALES_TRANSACTIONS_EXT
. . exporting table     SUPPLEMENTARY_DEMOGRAPHICS       4500 rows exported
. . exporting table                          TIMES       1826 rows exported
. about to export PM's tables via Conventional Path ...
. . exporting table                   ONLINE_MEDIA          9 rows exported
. . exporting table                    PRINT_MEDIA          4 rows exported
. . exporting table             TEXTDOCS_NESTEDTAB         12 rows exported
. about to export BI's tables via Conventional Path ...
. about to export ZLM's tables via Conventional Path ...
. . exporting table                             T1     201420 rows exported
. . exporting table                             T2          2 rows exported
. exporting synonyms
. exporting views
. exporting referential integrity constraints
. exporting stored procedures
. exporting operators
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting triggers
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting user history table
. exporting default and system auditing options
. exporting statistics
Export terminated successfully with warnings.
[oracle@ora10g ~]$ exit
exit
[oracle@ora10g ~]$ ll -lrth |grep fulldb.dmp
-rw-r--r--  1 oracle oinstall 108M Nov 21 11:42 fulldb.dmp
[oracle@ora10g ora10g]$ pwd
/u01/app/oracle/oradata/ora10g
[oracle@ora10g ora10g]$ du -sh *.dbf
101M    example01.dbf
271M    sysaux01.dbf
561M    system01.dbf
23M     temp01.dbf
166M    undotbs01.dbf
31M     users01.dbf
51M     zlm01.dbf

导出文件非常小,仅仅有108M。而实际的数据库中的数据文件有1.2G

总结:

exp/imp通常在Oracle 8i/9i等早期的版本号中用得较多,到了10g以后基本全面被数据库泵(Data Pump)代替,即expdp/impdp,尽管说已经是过时的技术。但作为DBA也不能全然不了解,由于和数据泵还是有异曲同工之处的,仅仅是数据泵的功能更强大了。

本篇实验採用了一个最不有用的方法来演示exp/imp的用法,即:交互方式。该方式可支配的參数很少,如。不能指定log。feedback等參数,也不能指定按条件进行导出。且每次使用起来都要一步步确认许多的步骤,很繁琐,不推荐使用,即便要使用。也推荐採用另外两种方式:1.命令行模式、2.參数文件模式(推荐)。


posted @ 2016-01-03 09:01  blfshiye  阅读(941)  评论(0编辑  收藏  举报