From oracle-l-bounce@freelists.org Mon Apr 12 17:33:22 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i3CMXHw17933 for ; Mon, 12 Apr 2004 17:33:17 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i3CMXC617924 for ; Mon, 12 Apr 2004 17:33:17 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 18D20634AE4; Mon, 12 Apr 2004 17:27:42 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 32557-70; Mon, 12 Apr 2004 17:27:41 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5F70B634A64; Mon, 12 Apr 2004 17:27:41 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 12 Apr 2004 17:26:26 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EC69B634A42 for ; Mon, 12 Apr 2004 17:26:25 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 32181-70 for ; Mon, 12 Apr 2004 17:26:25 -0500 (EST) Received: from mail.sagelogix.com (unknown [69.15.85.3]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6A47D634A2F for ; Mon, 12 Apr 2004 17:26:25 -0500 (EST) Received: by mail.sagelogix.com (Postfix, from userid 70101) id 26A68316F8; Mon, 12 Apr 2004 16:25:18 -0600 (MDT) Received: from ocs.sagelogix.com (ocs.sagelogix.com [192.168.25.20]) by mail.sagelogix.com (Postfix) with ESMTP id 020F0316F0; Mon, 12 Apr 2004 16:25:03 -0600 (MDT) Received: from ocs.sagelogix.com by ocs.sagelogix.com with ESMTP id 1071921081805007; Mon, 12 Apr 2004 15:23:27 -0600 Message-ID: <4853729.1081805007083.JavaMail.oracle@ocs.sagelogix.com> Date: Mon, 12 Apr 2004 15:23:27 -0600 (MDT) From: tim@sagelogix.com To: oracle-l@freelists.org Subject: Re: Database Archive Mime-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 X-Mailer: Oracle Webmail Client(UIX) X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on mail.sagelogix.com X-Spam-Level: X-Spam-Status: No, hits=-2.9 required=2.3 tests=BAYES_00,NO_REAL_NAME autolearn=no version=2.63 X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2904 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: tim@sagelogix.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@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 -----------------------------------------------------------------