Re: Archiving Financials Data

Do you have access to another server that you could keep an archive copy of the database on?
That's what we did. We copied the database to another server, which is up and running all the time.
We gave people read-only access to the data, to prevent accidents. We then purged each archived
financial year (1993,1994 and 1995 in this case) from the live system, including AP. This freed up lots of space on the live system, while allowing instant access to the historical data. If you don't have access to a 'spare' server, I'm not sure how you would go about doing this.  

>==========Hoa Le, 23/10/96==========
>
>Systems Admin (sysadmin_at_doj.vic.gov.au) wrote:
>: 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
>

Sally Pearce
Financials DBA(for my sins) Received on Fri Oct 25 1996 - 00:00:00 CDT