Hi Nancy
One way we did it three / four years ago whilst working on a finance
system was to build a second archive database. The main database table
in the production system held details of the financial transactions and
was partitioned into 13 partitions split on months, at each month end
the
of list ORACLE-L
Subject: RE: archive old data
I really appreciate all replies. Those solutions are very
good. I think
partition works for our case.
Nancy
From: Stephane Faroult [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED
Nancy:
It's the standard answer: It Depends.
We are running SAP, and SAP has it's own flavor of archiving, and
each transaction type has it's own archiving rules. Archived
data is stored in special files that SAP can read, so that even
though the data is no longer in the Oracle database, it is
Nancy,
As with so many things, it depends.
If you *might* need some of the data back, then you need to be able to
recover it. That means if you do an export, you need to know what
version it is and track whether that table ever has any changes. If it
does change, you will need to jump through
Title: RE: archive old data
Hi Nancy,
Unless you are having serious performance / storage problems or another valid option would be just to delete the data, don't do it.
I inherited a database where we archive data yearly. I started working on the checklist and scripts last month and we
In an ideal world, tables are partitioned and you just have to archive partitions -
either to other tables in an ARCHIVE schema, or by exporting them - and then you can
truncate them (=partitions). In the real world, you always have some rows at a very
old date which are *not* in the CLOSED
]
Date: 2003/09/12 Fri PM 01:24:24 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: archive old data
Nancy,
As with so many things, it depends.
If you *might* need some of the data back, then you need to be able to
recover it. That means if you do an export, you
I really appreciate all replies. Those solutions are very good. I think
partition works for our case.
Nancy
From: Stephane Faroult [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: archive old data
Date: Fri, 12 Sep 2003 09
: archive old data
I really appreciate all replies. Those solutions are very
good. I think
partition works for our case.
Nancy
From: Stephane Faroult [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: archive old