| purging of data [message #64742] |
Thu, 15 January 2004 14:58  |
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  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
