SQL> col owner for a10
SQL> col DIRECTORY_PATH for a50
SQL> select * from dba_directories;
OWNER DIRECTORY_NAME DIRECTORY_PATH
---------- --------------------------------------------------------------------------------
SYS ORACLE_OCM_CONFIG_DIR /u01/app/oracle/11.2.0/db_1/ccr/state
SYS DATA_PUMP_DIR /u01/app/oracle/admin/dave/dpdump/
SYS XMLDIR /u01/app/oracle/11.2.0/db_1/rdbms/xml
SQL>
SQL> create directory backup as'/u01/backup';
Directory created.
SQL> select * from dba_directories;
OWNER DIRECTORY_NAME DIRECTORY_PATH
---------- --------------------------------------------------------------------------------
SYS ORACLE_OCM_CONFIG_DIR /u01/app/oracle/11.2.0/db_1/ccr/state
SYS DATA_PUMP_DIR /u01/app/oracle/admin/dave/dpdump/
SYS XMLDIR /u01/app/oracle/11.2.0/db_1/rdbms/xml
SYS BACKUP /u01/backup
--创建测试表：tianlesoftware：
SQL> conn system/oracle;
Connected.
SQL> create table tianlesoftware asselect * from dba_objects;
Table created.
--使用trace：480300进行导出：
[oracle@asm u01]$ expdp system/oracleDIRECTORY=backup DUMPFILE=dave.dmp LOGFILE=dave.log TABLES=tianlesoftwareTRACE=480300
Export: Release 11.2.0.3.0 - Production onMon May 27 19:50:49 2013
Copyright (c) 1982, 2011, Oracle and/or itsaffiliates. All rights reserved.
Connected to: Oracle Database 11gEnterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic StorageManagement, OLAP, Data Mining
and Real Application Testing options
Starting"SYSTEM"."SYS_EXPORT_TABLE_01": system/******** DIRECTORY=backupDUMPFILE=dave.dmp LOGFILE=dave.log TABLES=tianlesoftware TRACE=480300
Estimate in progress using BLOCKS method...
Processing object typeTABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 9 MB
Processing object typeTABLE_EXPORT/TABLE/TABLE
Processing object typeTABLE_EXPORT/TABLE/PRE_TABLE_ACTION
. . exported"SYSTEM"."TIANLESOFTWARE" 7.215 MB 74608 rows
Master table"SYSTEM"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_TABLE_01is:
/u01/backup/dave.dmp
Job"SYSTEM"."SYS_EXPORT_TABLE_01" successfully completed at19:51:22
--查看trace文件：
-rw-r----- 1 oracle asmadmin 1433 May 27 19:51 dave_dw00_7486.trm
-rw-r----- 1 oracle asmadmin 32109 May 27 19:51 dave_dw00_7486.trc
-rw-r----- 1 oracle asmadmin 1417 May 27 19:51 dave_dm00_7484.trm
-rw-r----- 1 oracle asmadmin 25025 May 27 19:51 dave_dm00_7484.trc
-rw-r----- 1 oracle asmadmin 2908 May 27 19:50 dave_ora_7480.trc
[oracle@asm trace]$ head -50 dave_dw00_7486.trc
Trace file/u01/app/oracle/diag/rdbms/dave/dave/trace/dave_dw00_7486.trc
Oracle Database 11g Enterprise EditionRelease 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic StorageManagement, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/11.2.0/db_1
System name: Linux
Node name: asm
Release: 2.6.32-100.34.1.el6uek.x86_64
Version: #1 SMP Wed May 25 17:46:45 EDT 2011
Machine: x86_64
Instance name: dave
Redo thread mounted by this instance: 1
Oracle process number: 42
Unix process pid: 7486, image: oracle@asm(DW00)
*** 2013-05-27 19:50:55.052
*** SESSION ID:(24.127) 2013-05-2719:50:55.052
*** CLIENT ID:() 2013-05-27 19:50:55.052
*** SERVICE NAME:(SYS$BACKGROUND) 2013-05-2719:50