reducing size of a database [message #20072] |
Mon, 29 April 2002 00:02 |
Oscar
Messages: 6 Registered: November 2001
|
Junior Member |
|
|
hi
my database becomes too big after a few days. how can i say that if the table reaches a number of lines or a defined memorysize to delete (or better archive) the oldest data?
thanks
|
|
|
Re: reducing size of a database [message #20180 is a reply to message #20072] |
Fri, 03 May 2002 23:57 |
srinivasarao
Messages: 15 Registered: April 2002
|
Junior Member |
|
|
make a table into partitions
move the entire not required data into old partition
which ever new data comes into the new partition
if you require you can view the old data also
if your table space is full add one more datafile with sufficiant space
i think no need to complete remove the data from table
regards
srinivasarao.p
|
|
|