【Oracle导入导出】expdp

1.查看数据泵的目录对象，目录对象是数据泵导出数据时存放的文件路径：

[sql]

SQL> SELECT * FROM dba_directories;

OWNER DIRECTORY_NAME DIRECTORY_PATH

------------------------------ ------------------------------ --------------------------------------------------------------------------------

SYS ADMIN_DIR /ade/aime_10.2_lnx_push/oracle/md/admin

SYS DATA_PUMP_DIR /home/oracle/oracle/product/10.2.0/db_1/rdbms/log/

SYS WORK_DIR /ade/aime_10.2_lnx_push/oracle/work

只有SYS或者SYSTEM用户才能使用默认DATA_PUMP_DIR目录对象

所以SYSTEM用户可以启用数据泵导出作业，而不需要提供目录名。

[plain]

[oracle@localhost ~]$ expdp system/lubinsu

Export: Release 10.2.0.1.0 - Production on Wednesday, 01 May, 2013 17:04:18

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/********

Estimate in progress using BLOCKS method...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 320 KB

Processing object type SCHEMA_EXPORT/USER

Processing object type SCHEMA_EXPORT/SYSTEM_GRANT

Processing object type SCHEMA_EXPORT/ROLE_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM

Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC

Processing object type SCHEMA_EXPORT/DB_LINK

Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Processing object type SCHEMA_EXPORT/TABLE/PRE_TABLE_ACTION

Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type SCHEMA_EXPORT/TABLE/GRANT/CROSS_SCHEMA/OBJECT_GRANT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/TABLE/COMMENT

Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC

Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE

Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC

Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE

Processing object type SCHEMA_EXPORT/VIEW/VIEW

Processing object type SCHEMA_EXPORT/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type SCHEMA_EXPORT/VIEW/GRANT/CROSS_SCHEMA/OBJECT_GRANT

Processing object type SCHEMA_EXPORT/VIEW/COMMENT

Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/TRIGGER

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Processing object type SCHEMA_EXPORT/TABLE/POST_TABLE_ACTION

Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA

. . exported "SYSTEM"."REPCAT$_AUDIT_ATTRIBUTE" 5.953 KB 2 rows

. . exported "SYSTEM"."REPCAT$_OBJECT_TYPES" 6.507 KB 28 rows

. . exported "SYSTEM"."REPCAT$_RESOLUTION_METHOD" 5.648 KB 19 rows

. . exported "SYSTEM"."REPCAT$_TEMPLATE_STATUS" 5.296 KB 3 rows

. . exported "SYSTEM"."REPCAT$_TEMPLATE_TYPES" 5.914 KB 2 rows

. . exported "SYSTEM"."DEF$_AQCALL" 0 KB 0 rows

. . exported "SYSTEM"."DEF$_AQERROR" 0 KB 0 rows

. . exported "SYSTEM"."DEF$_CALLDEST" 0 KB 0 rows

. . exported "SYSTEM"."DEF$_DEFAULTDEST" 0 KB 0 rows

. . exported "SYSTEM"."DEF$_DESTINATION" 0 KB 0 rows

. . exported "SYSTEM"."DEF$_ERROR" 0 KB 0 rows

. . exported "SYSTEM"."DEF$_LOB" 0 KB 0 rows

. . exported "SYSTEM"."DEF$_ORIGIN" 0 KB 0 rows

. . exported "SYSTEM"."DEF$_PROPAGATOR" 0 KB 0 rows

. . exported "SYSTEM"."DEF$_PUSHED_TRANSACTIONS" 0 KB 0 rows

. . exported "SYSTEM"."DEF$_TEMP$LOB" 0 KB 0 rows

. . exported "SYSTEM"."LOGSTDBY$APPLY_MILESTONE" 0 KB 0 rows

. . exported "SYSTEM"."LOGSTDBY$APPLY_PROGRESS":"P0" 0 KB 0 rows

. . exported "SYSTEM"."LOGSTDBY$EVE

上一个：Oracle处理指定分隔符中的字符串
下一个：【Oracle】比较快的删除重复数据的方式

更多图片编程知识:

更多Oracle疑问解答：: 运行exp备份oracle数据库提示oracle-12154错误; 有没有，生产Oracle Rman 备份脚本的工具啊！; 初学orcle，希望有大大帮忙解说一下详细步骤，从登录oracle到创建表的过程; oracle语句问题：一张user表，三个字段，id,name,time，插入记录比如：张三2007，李四2008，张三2011; 如何写一个ORACLE触发器同步两个表中的数据？; oracle 如何查看一个服务器上有多少个数据库.; oracle 创建包的时候错误求解; oracle 重复列的问题; oracle 中如何查处2星期前的数据; 请教oracle数据库安装中的问题; 请问谁能提供给我标准的oracle ERP的数据库表结构并详细说明各表主要的作用?; 安装oracle遇到的问题 invalid entry CRC (expected 0x3e12e795 but got 0x9db0e9fd); 我的是ORACLE 10G，在RMAN中如何按指定的时间恢复数据文件啊？; oracle为什么没有自动增长列; oracle快捷键都有哪些啊？