Migration of Oracle Jobs [message #483441] |
Mon, 22 November 2010 03:32 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
pokhraj_d
Messages: 117 Registered: December 2007
|
Senior Member |
|
|
Hi,
Recently we are planning to migrate oracle 10g to 11g.
We are migrating PHASEWISE (Schema wise) as this is a 50TB of Production instance.
We are using Oracle Golden gate for this purpose.
Is there is any way that we can migrate oracle jobs from 10g to 11g?
Please advice...
Regards
P
|
|
|
|
Re: Migration of Oracle Jobs [message #483471 is a reply to message #483454] |
Mon, 22 November 2010 06:13 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
pokhraj_d
Messages: 117 Registered: December 2007
|
Senior Member |
|
|
Hi,
The below is my actual situation:-
I have some scheduled jobs running at 10g.
I quired from dba_scheduler_jobs and got the below jobs:-
1. CREATE_AUDIT_TABLE_PARTITION
2. GATHER_STATS_JOB
3. PURGE_LOG
I want to migrate those above jobs from 10g to 11g.
What will be the procedure.
Thanks -
P
|
|
|
|
|
|
Re: Migration of Oracle Jobs [message #483518 is a reply to message #483511] |
Mon, 22 November 2010 11:15 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
If they're your own jobs you should have scripts to create them.
Export and Expdp should export them.
No idea what goldengate does.
Gather_stats_job and purge_log are oracle created jobs that should already be present on the new db (or equivalent jobs).
|
|
|