Re: Archiving Financials Data

In article <54l5m6$a1_at_freenet-news.carleton.ca>, Manh-Hoa Le <at770_at_FreeNet.Carleton.CA> writes
>
>Systems Admin (sysadmin_at_doj.vic.gov.au) writes:
>> We need to archive some historical Oracle Financials data, but we can't
>> put it to tape since the users need regular access to it. Our Financials
>> database is growing, and we need to keep at least 7 years' data for legal
>> reasons.
>>
>> Does anybody have a solution to this? We can't be the only site with this
>> problem!
>
> Add a 'transaction date' column to each table. That way you can keep
> data for the last 7 years. Please let me know if you have others
> solutions.
>
> Hoa Le ("Leh")
> Oracle Consultant

You should _never_ add columns to a database, Oracle Corporation will not support your installation under standard support contracts, and you _may_ loose these columns when you upgrade. In any case this is a much bigger issue. The original question doesnt say which products we are talking about, GL, AP +++?   

-- 
Mark Cherry