RE: DBMS_Schedule

  • From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • To: <smishra_97@xxxxxxxxx>
  • Date: Mon, 14 Nov 2005 17:33:55 +0100

Hi Sanjay

>I tried include=job but got an error
>
>Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 
>64bit Production
>With the Partitioning, OLAP and Data Mining options
>Starting "SMR5"."SYS_EXPORT_SCHEMA_01":  smr5/******** 
>dumpfile=datapump_dir:jobs.dmp include=job
>logfile=datapump_dir:jobs.log
>Estimate in progress using BLOCKS method...
>Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
>Total estimation using BLOCKS method: 0 KB
>ORA-39168: Object path JOB was not found.
>ORA-31655: no data or metadata objects selected for job
>Job "SMR5"."SYS_EXPORT_SCHEMA_01" completed with 2 error(s) at 10:26:22

You can select the available paths from the DD view DATAPUMP_PATHS. 


HTH
Chris

New Features Oracle Database 10g Release 2 seminars @ www.trivadis.com
Italiano: Lugano (24-Nov)
Français: Genève (17-Nov)
Deutsch: Zürich (29-Nov), Stuttgart (13-Dec)
--
//www.freelists.org/webpage/oracle-l


Other related posts: