Message-ID: <F001.004FD168.20021106121016@fatcity.com>
Date: Wed, 06 Nov 2002 12:10:16 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: Rachel Carmichael <wisernet100@yahoo.com>
Subject: RE: Data Purging Strategy
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Port finish is better :)


--- Jared.Still@radisys.com wrote:
> That reminds me:
> 
> Mark, your annual stipend is due.
> 
> Make it a case of Glenmorangie this time, Sherry finish.  :)
> 
> Jared
> 
> 
> 
> 
> 
> 
> John.Hallas@vodafone.co.uk
> Sent by: root@fatcity.com
>  11/06/2002 07:56 AM
>  Please respond to ORACLE-L
> 
>  
>         To:     Multiple recipients of list ORACLE-L
> <ORACLE-L@fatcity.com>
>         cc: 
>         Subject:        RE: Data Purging Strategy
> 
> 
> Hey Dennis,
> Mark Leith is the only person on this list allowed to mention 3rd
> party
> products.
> I am sure he bought the franchise from Jared :)
> 
> John
> 
> -----Original Message-----
> Sent: 06 November 2002 14:15
> To: Multiple recipients of list ORACLE-L
> 
> 
> Prem - You are receiving some excellent advice from Tom and Tim. I
> would
> mention two items in addition:
>   - If you ever hope to re-use the data you archive off-line, you
> must 
> also
> archive all the related tables, because after all, this is a
> RELATIONAL
> database.
>   - PrincetonSoftech has a product Active Archiving that looks pretty
> good
> from the demos I've seen. I haven't used it myself.
> 
> 
> 
> Dennis Williams 
> DBA, 40%OCP 
> Lifetouch, Inc. 
> dwilliams@lifetouch.com 
> 
> -----Original Message-----
> Sent: Wednesday, November 06, 2002 6:54 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Prem,
>  
> I would re-visit the requirement.  Why do you feel the need to delete
> the
> data from the database?  What is the purpose for this type of
> requirement?
> It would be far easier to modify the requirement than to do what you
> are
> thinking of doing.
>  
> Adding columns to database tables indicating that a record has passed
> it's
> retention policy and thus, is not included in queries, would be a
> much
> easier solution.
>  
> Or, simply moving these records to historical tables in the database
> - and
> NOT deleting them from the system - is a much better solution.  The
> data 
> is
> always accessible and not available in the current tables.  And you
> will 
> not
> be playing the "get the data from tape and reload it" game with all
> of 
> it's
> problems (writing an offload program, table structure changes &
> offload
> program versions).
>  
> Try and keep this as simple as possible.
>  
> Hope this helps
>  
> Tom Mercadante 
> Oracle Certified Professional 
> 
> -----Original Message-----
> Sent: Wednesday, November 06, 2002 4:13 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> 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: DENNIS WILLIAMS
>   INET: DWILLIAMS@LIFETOUCH.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@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).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: John.Hallas@vodafone.co.uk
> 
> 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@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).
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: Jared.Still@radisys.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@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).


__________________________________________________
Do you Yahoo!?
HotJobs - Search new jobs daily now
http://hotjobs.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: wisernet100@yahoo.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@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).