RE: DBMS_Schedule

From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Mon, 14 Nov 2005 08:41:58 -0800 (PST)
Message-ID: <20051114164159.50228.qmail@web51308.mail.yahoo.com>

Chris    

  I can see the following but don't know as how to use it with Export dump

  JOB                                      SCHEMA_EXPORT/JOB
SCHEMA_EXPORT/JOB                        SCHEMA_EXPORT/JOB
JOB                                      DATABASE_EXPORT/SCHEMA/JOB
SCHEMA/JOB                               DATABASE_EXPORT/SCHEMA/JOB
DATABASE_EXPORT/SCHEMA/JOB               DATABASE_EXPORT/SCHEMA/JOB

   

  Any help is appreciated    

  Thanks
  Sanjay

Christian Antognini <Christian.Antognini_at_trivadis.com> wrote:   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)                    

---

 Yahoo! FareChase - Search multiple travel sites in one click.

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

Received on Mon Nov 14 2005 - 10:44:10 CST