DBMS_Schedule

From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Mon, 14 Nov 2005 08:20:54 -0800 (PST)
Message-ID: <20051114162054.27512.qmail@web51301.mail.yahoo.com>

 

  Can anybody suggest the syntax for moving the DBMS_SCHedule Jobs from one Schema to another as well as from one database to another.    

  I had a schema smr5 which contains around 20-25 jobs created using DBMS_SCHEDULE. Oracle Administration manual (chapter 28) says that consult Oracle utility manual to move the jobs from one db to another but I am not able to find it.   http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14231/schedadmin.htm#sthref3693        

  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    

  TIA
  Sanjay                 

---

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

http://www.freelists.org/webpage/oracle-l Received on Mon Nov 14 2005 - 10:22:55 CST