Home » RDBMS Server » Server Administration » Stop and Resume a process
Stop and Resume a process [message #174954] Wed, 31 May 2006 02:48 Go to next message
adhivasam
Messages: 1
Registered: May 2006
Location: Chennai
Junior Member
Hi,
I am going to call a sql script from unix box in one weekend.
And i want to stop it monday morning and resume the same in the next week end.

The script should continue from where it stops and should not restart once again the process.

(The script is to update a table which contains millions of records.)

Is there any way to do like this?
Can any pls tell me the way that i can proceed.

Thanks,
Adhi..

Report message to a moderator

Re: Stop and Resume a process [message #174979 is a reply to message #174954] Wed, 31 May 2006 05:35 Go to previous message
aciolac
Messages: 242
Registered: February 2006
Senior Member
See documentation about ORADEBUG utility. He can suspend and resume Oracle process.

Report message to a moderator

Previous Topic: Literal value
Next Topic: installing oracle 9i r2 on fedora core 5
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 12:31:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.