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


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

Original text of this message