Home » RDBMS Server » Server Administration » Default Jobs in Oracle 10G
Default Jobs in Oracle 10G [message #220630] Wed, 21 February 2007 07:58
toshidas2000
Messages: 120
Registered: November 2005
Senior Member
All
I had to drop the two default jobs in oracle 10g purge logs and GATHER_STATS_JOB before appling DST Patch. Now I want them to put it back?? How do I do that??
I used following to drop

begin
2 DBMS_SCHEDULER.DROP_JOB('GATHER_STATS_JOB');
3 END;
4 /
Previous Topic: upgrade from 8 to 10
Next Topic: ASM
Goto Forum:
  


Current Time: Sat Dec 03 01:30:53 CST 2016

Total time taken to generate the page: 0.11443 seconds