Database Administration (MOSC)

MOSC Banner

How to retain dba_jobs after refresh in 9i

edited Nov 13, 2008 5:37AM in Database Administration (MOSC) 2 comments
We have some jobs schuduled in Test instance (Oracle DB 9.2.0.7) using dbms_job package. TEST is refreshed from Prod everynight which means it overrides all the scheduled jobs.  
I want to prevent overwriting the jobs.
So i thought of exporting sys.job$ table and import post refresh. But i get errors while trying to export sys.job$ because of the below 3 columns
 CUR_SES_LABEL                                      MLSLABEL
 CLEARANCE_HI                                       MLSLABEL
 CLEARANCE_LO                                       MLSLABEL
 
When i search meatalink it says these columns are obosolete starting Oracle 8.
 
Any expert advise on this???
 

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