How to retain dba_jobs after refresh in 9i
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
CLEARANCE_HI MLSLABEL
CLEARANCE_LO MLSLABEL
When i search meatalink it says these columns are obosolete starting Oracle 8.
Any expert advise on this???
0