Database Utilities (MOSC)

MOSC Banner

When using datapump parameter EXCLUDE=JOB, is it possible to include the optional name clause?

edited Mar 5, 2020 4:48AM in Database Utilities (MOSC) 4 commentsAnswered

Oracle Server EE 11gR2 on AIX 7.1

I am using Oracle datapump export and import to copy data from a production database to a test database. Our application developers scheduled production jobs using both DBMS_SCHEDULER and DBMS_JOBS. I prevent import of those jobs into the test database using two EXCLUDE parameters. Use of EXCLUDE for this purpose is described in Oracle Support document, How To Exclude Scheduler Job From Data Pump Export (expdp) (Doc ID 1414478.1).

I prevent import of the DBMS_SCHEDULER jobs using the following statement in the import parameter file.:

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center