Re: Archiving Financials Data
From: Manh-Hoa Le <at770_at_FreeNet.Carleton.CA>
Date: 1996/10/23
Message-ID: <54l5m6$a1_at_freenet-news.carleton.ca>#1/1
Date: 1996/10/23
Message-ID: <54l5m6$a1_at_freenet-news.carleton.ca>#1/1
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
Received on Wed Oct 23 1996 - 00:00:00 CEST