| Recyling records in a large table. [message #63532] |
Wed, 13 October 2004 12:12  |
Tariq
Messages: 11
Registered: July 2003
|
Junior Member |
|
|
Anyone has any script or procedure to recycle records in a huge table.
We have a table, which has couple of millions of records every day. I dont know if its possible or not to overwrite the old records with new ones say every 100,000 records.
Partioning is not an option....
BTW we have Oracle 8.1.7 & solaris 8
Thanks in advance!
--tariq
|
|
|
|
| Re: Recyling records in a large table. [message #63568 is a reply to message #63532] |
Sat, 16 October 2004 21:13  |
Balaji
Messages: 102
Registered: October 2000
|
Senior Member |
|
|
hi tariq ,
please tell me what does ur term overwrite the old records mean. do you need to update all the columns except a column that identifies that the record is old , or do you need to replace the entire row which is identified as old with current data .
an easy option is to move the data which u feel as old to a repository outside your production database.then delete those rows to make way for new ones.
with best wishes
balaji
|
|
|
|
|
|
| Re: Recyling records in a large table. [message #63583 is a reply to message #63580] |
Mon, 18 October 2004 18:06 |
jack
Messages: 123
Registered: September 2000
|
Senior Member |
|
|
You can add two columns for that table. Both are numbers. One is used to remeber the number of the rows. Another used to mark the last recycled record. When the table reachs a certain number, you can use a trigger or outside sql clause to update the oldest one in the table.
Hope it can help you!
Jack
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
