This is exactly the topic that Jeff Maresh wrote about in his "Managing the Data Lifecycle" paper, available online at "http://www.EvDBT.com/papers.htm". I think it's going to be in SELECT magazine soon, too...
There is no need to take data "offline" for archival, at least in Oracle. The benefits discussed in the article can become immediately available when range-partitioning by date along with the storage cost benefits of near-line storage. Migration of data from one storage media to another can occur with little or no interruption to user access.
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at
http://www.freelists.org/archives/oracle-l/
FAQ is at
http://www.freelists.org/help/fom-serve/cache/1.html
Received on Mon Apr 12 2004 - 17:33:22 CDT
