众所周知，用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 >
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个选项了
--默认是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。表示使用追加的方式导入。并不会覆盖原来的数据，也不会由于对象已经存在而终止导入
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
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 >
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.參数文件模式（推荐）。