Home » RDBMS Server » Performance Tuning » purging of data
purging of data [message #64742] Thu, 15 January 2004 14:58 Go to next message
jun
Messages: 7
Registered: May 2003
Junior Member
i would like to ask the ff:

>is there any procedures on  having weekly or monthly purging of data that is no longer needed in the database.

>is there any way that this procedure would help me to have more space in the hardisk??

ty
Re: purging of data [message #64743 is a reply to message #64742] Thu, 15 January 2004 23:24 Go to previous messageGo to next message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member
Hi,

Well very first just clear the term "no longer needed", how can u identify that wht is not needed now?

If u can than just create a procedure which will delete the records from the respective tables according to ur definition of "no longer needed" and sehedule it on daily/weekly/monthly whtever u want basis. For creating the job use DBMS_JOB package.
Here is an example to submit a fresh job which will run at 12'O clock after every thirty days.

declare
a number;
begin
DBMS_JOB.SUBMIT(a,'proc_name;',sysdate,'trunc(sysdate)+30');
end;

For more refer oracle doc.
Re: purging of data [message #64747 is a reply to message #64742] Sat, 17 January 2004 06:43 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Also see this thread --> Reclaim space

-Thiru

[Updated on: Fri, 18 February 2005 23:32]

Report message to a moderator

Previous Topic: how to force the sql query to use or not to use index
Next Topic: Views
Goto Forum:
  


Current Time: Fri Mar 29 02:14:19 CDT 2024