oracle11g如何单独导出job的示例

 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

发表评论:

◎欢迎参与讨论,请在这里发表您的看法、交流您的观点。

«    2024年11月    »
123
45678910
11121314151617
18192021222324
252627282930
搜索
标签列表
网站分类
最新留言
    文章归档
    友情链接

    Powered By Z-BlogPHP 1.7.3

    Copyright Your WebSite.Some Rights Reserved.闽ICP备11018667号-2