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).