Re: Archiving historical data

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Wed, 27 Feb 2002 10:35:29 +1100
Message-ID: <a5h64t$5mi$1@lust.ihug.co.nz>

Transportable Tablespaces, together with some judicious range partitioning.

Once your data is partitioned, you can house each month (say) in separate data files. Make them read only, export with transport_tablespace=y, burn the export dump file and the datafile onto a CD (or similar), and then drop the relevant partitions. Restoration is a matter of moments spent re-plugging in the datafiles off CD.

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"Sathish Balas" <sathishrani_at_home.com> wrote in message
news:MvUe8.23405$BW5.9727048_at_news1.rdc1.va.home.com...


> Anybody could share with me ideas about how historical data is archived ?

We


> have a database with 3 yrs data . we want to

> archive 2 yrs data . We would need to restore 2 years data within 3 days .

> Any ideas ....

>

> --

> Sathish B

>

>

Received on Tue Feb 26 2002 - 17:35:29 CST