Scott,
You're walking where angels fear to tread.
Watch it.
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/08/2002 09:25 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Data Purging Strategy
Burnt mud? Isn't that all scotch?
Scott Shafer
San Antonio, TX
210.581.6217
> -----Original Message-----
> From: Steve McClure [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, November 06, 2002 4:34 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Data Purging Strategy
>
> Sherry Finish? I thought you liked scotch that tasted like burnt mud?
>
> -----Original Message-----
> [EMAIL PROTECTED]
> Sent: Wednesday, November 06, 2002 10:55 AM
> To: Multiple recipients of list ORACLE-L
>
>
> That reminds me:
>
> Mark, your annual stipend is due.
>
> Make it a case of Glenmorangie this time, Sherry finish. :)
>
> Jared
>
>
>
>
>
>
> [EMAIL PROTECTED]
> Sent by: [EMAIL PROTECTED]
> 11/06/2002 07:56 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> 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.
> [EMAIL PROTECTED]
>
> -----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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: Steve McClure
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
