以交互方式使用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(*)

----------

SQL> !

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

--运行导出t1表

[oracle@ora10g ~]$ exp

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

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

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

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 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

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

"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

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 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

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

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 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

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 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(*)

----------

如今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

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(*)

----------

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

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

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(*)

----------

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

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(*)

----------

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

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.參数文件模式（推荐）。

秒客网

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

相关文章