Data Purging Strategy

From: <prem_at_ibsplc.com>
Date: Wed, 06 Nov 2002 01:13:28 -0800
Message-ID: <F001.004FC780.20021106011328@fatcity.com>

Dear List,

I need some inputs from you all regarding purging data from the database.

This is the requirement

We define a retention period for all the data in the system. When the retention period is reached, the data should be deleted, but then at a later time, some user might request for this purged data. So it must be possible to retrieve this data.

This is the strategy we have designed for this.

When the retention period is reached, move the data from the main database to an offline database. Then delete the data from the main database.

In the offline database, we cannot again keep it from long, so it has to moved to tapes. Now my question, how can we move this data to tapes and at the same time retrieve data from the tapes based on dates. i.e, the user will ask for the data on a particular date, so it must be possible to retrieve data from the tapes based on a date and load it to the database tables.

Regards
Prem  

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: prem_at_ibsplc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Nov 06 2002 - 03:13:28 CST