Re: Archieval of data

From: Jim Kennedy <kennedy-down_with_spammers_at_no_spam.comcast.net>
Date: Thu, 21 Aug 2003 03:52:40 GMT
Message-ID: <cmX0b.160896$It4.79467@rwcrnsc51.ops.asp.att.net>

You might look into partitioning. Each month you would partition off those closed sales records into another tablespace. Backup the tablespace and then take it off line and then delete it. But I think Ana's idea is better unless you really really have gobs of data. To get it back you would have to put the file back and bring the tablespace on line.

You would have to try it.(on a development system)

Jim
"Shafeek Khalidh" <itsprobablyme_at_msn.com> wrote in message news:bi1ei3$44mm0$1_at_ID-137434.news.uni-berlin.de...
> Ana, here we are moving only closed sales records after 6 months, if its
not
> closed, we have to keep it, we have to handle this using procedures which
> checks the data based on the business rules, And we are not at all
touching
> the master tables.
>
> Thanks
>
>
Received on Wed Aug 20 2003 - 22:52:40 CDT