1、查询要导出的目录在哪里:select * from dba_directories;
/archivelog/itlife365dbbak/
2、使用expdp 命令导出,主要include=job 只是导出job ,其他的没有进行导出。目前我测试是这样的结果。
itlife365$ expdp itlife365/com directory=EXPDIR dumpfile=itlife365_job.dp include=job
Export: Release 11.1.0.7.0 - 64bit Production on Friday, 15 November, 2013 17:48:19
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "ITLIFE365"."SYS_EXPORT_SCHEMA_02": itlife365/******** directory=EXPDIR dumpfile=itlife365_job.dp include=job
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
Processing object type SCHEMA_EXPORT/JOB
Master table "ITLIFE365"."SYS_EXPORT_SCHEMA_02" successfully loaded/unloaded
******************************************************************************
Dump file set for ITLIFE365.SYS_EXPORT_SCHEMA_02 is:
/archivelog/itlife365dbbak/itlife365_job.dp
Job "ITLIFE365"."SYS_EXPORT_SCHEMA_02" successfully completed at 17:48:42