Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Exporting scheduled jobs via DBMS_DATAPUMP

User778513-OracleFeb 19 2013 — edited Feb 19 2013

Hi,

I am trying to export a schema and import into a new db. I am doing a schema import of 1 specific schema alone.
I am having issues exporting the scheduled jobs.

#1. Jobs that have completed successfully have the changed "state" to "DISABLED" instead of "COMPLETED"
#2. Jobs that are scheduled also change the state to "DISABLED".
#3. The job arguments in dba_scheduler_job_args are not being imported.

Can you please let me know what extra steps do I need to do while exporting for the above 3 to be successful ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 19 2013

Added on Feb 19 2013

#database-key-features, #export-import-sql-loader-external-tables

2 comments

678 views