RE: DBMS_Schedule

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Mon, 14 Nov 2005 17:33:55 +0100
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF205108@MSXVS04.trivadis.com>

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)

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Nov 14 2005 - 10:35:59 CST