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!

How to exclude scheduler job from dbms_datapump import job via dblink

Peter SchlaegerJan 18 2016 — edited Jan 19 2016

Does anybody knows the syntax in dbms_datapump.metadata_filter to exclude scheduler_jobs while using dbms_datapump import via dblink?

Im Metalink I found :

How to Filter Scheduler Jobs Via Data Pump API (Doc ID 2014494.1)

where they

EXCLUDE=PROCOBJ:"IN (SELECT NAME FROM sys.OBJ$ WHERE TYPE# IN (47,48,49,50,66,67,68,69,71,72,74))"

But they do not give the syntax for dbms_datapump.metadata_filter

Has anyone an Idea?

I am really wondering that I am the only who wants to exclude scheduler_jobs from dp import.

So does anyone has an Idea what to do ?

Thanks for you Help in advance

Peter

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 16 2016

Added on Jan 18 2016

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

2 comments

1,470 views