RE: Undelete Record
Use logminer http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/logminer. htm#17869 Regards Naveen -Original Message- Sent: Friday, December 20, 2002 12:14 PM To: Multiple recipients of list ORACLE-L Hi Listers, I have little problem : how to undelete record that we've delete and commit so I can restore again in my data, thanks a lot. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto 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.net -- Author: Naveen Nahata 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).
RE: Undelete Record
Hi Listers, I have little problem : Hmmm, that may not be a little problem at all how to undelete record that we've delete and commit so I can restore again in my data, thanks a lot. You can resort to conventional Oracle backup and recovery (other folk will tell you all about that). But if you have important data tables, you can audit them individually. We have. We also have people who are liable to do just this sort of thing. Using our auditing approach, we can recover immediately, even after a commit. Requires an audit table for each data table, with a pre-change trigger to capture each row before the DML statement. More details if you wish (after Christmas - I'm off!) peter edinburgh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto 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). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter 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).
RE: Undelete Record
the audit table works well, I've used it before and am implementing it now (after the fact, the code base updated orders incorrectly, I was told we don't want audit tables beforehand, now they are desperate) be careful with logminer, it's not intuitively obvious which statement is the one you want to recover and, if you do a lot of data refresh (we do a daily truncate and reload of a catalog schema) can give you LOTS of records to go through -- in our case, 11 million records in two days of logs --- Robson, Peter [EMAIL PROTECTED] wrote: Hi Listers, I have little problem : Hmmm, that may not be a little problem at all how to undelete record that we've delete and commit so I can restore again in my data, thanks a lot. You can resort to conventional Oracle backup and recovery (other folk will tell you all about that). But if you have important data tables, you can audit them individually. We have. We also have people who are liable to do just this sort of thing. Using our auditing approach, we can recover immediately, even after a commit. Requires an audit table for each data table, with a pre-change trigger to capture each row before the DML statement. More details if you wish (after Christmas - I'm off!) peter edinburgh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto 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). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter 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). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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).
RE: Undelete Record
If it is Oracle9i and AUM is in use and UNDO_RETENTION is set up properly, then flashback query can be the answer... - Kirti -Original Message- Sent: Friday, December 20, 2002 5:04 AM To: Multiple recipients of list ORACLE-L the audit table works well, I've used it before and am implementing it now (after the fact, the code base updated orders incorrectly, I was told we don't want audit tables beforehand, now they are desperate) be careful with logminer, it's not intuitively obvious which statement is the one you want to recover and, if you do a lot of data refresh (we do a daily truncate and reload of a catalog schema) can give you LOTS of records to go through -- in our case, 11 million records in two days of logs --- Robson, Peter [EMAIL PROTECTED] wrote: Hi Listers, I have little problem : Hmmm, that may not be a little problem at all how to undelete record that we've delete and commit so I can restore again in my data, thanks a lot. You can resort to conventional Oracle backup and recovery (other folk will tell you all about that). But if you have important data tables, you can audit them individually. We have. We also have people who are liable to do just this sort of thing. Using our auditing approach, we can recover immediately, even after a commit. Requires an audit table for each data table, with a pre-change trigger to capture each row before the DML statement. More details if you wish (after Christmas - I'm off!) peter edinburgh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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).
RE: Undelete Record
We're in this situation right now. A user has delete information and want it back. Problem is that we do not know when it was delete. I have restore 20 copies (days) of the table via import. Going with logminer would have been difficult since we do not know when the data was changed and we have a lot of redo generation. --- Naveen Nahata [EMAIL PROTECTED] a écrit : Use logminer http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/logminer. htm#17869 Regards Naveen -Original Message- Sent: Friday, December 20, 2002 12:14 PM To: Multiple recipients of list ORACLE-L Hi Listers, I have little problem : how to undelete record that we've delete and commit so I can restore again in my data, thanks a lot. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto 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.net -- Author: Naveen Nahata 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). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Stephane=20Paquette?= 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).
RE: Undelete Record
and if they caught the problem within the retention time and if there wasn't a lot of activity that would cause Oracle to overwrite the undo segment anyway... and and and while I like the idea of flashback query, I'd hate to depend on it for data recovery. --- Deshpande, Kirti [EMAIL PROTECTED] wrote: If it is Oracle9i and AUM is in use and UNDO_RETENTION is set up properly, then flashback query can be the answer... - Kirti -Original Message- Sent: Friday, December 20, 2002 5:04 AM To: Multiple recipients of list ORACLE-L the audit table works well, I've used it before and am implementing it now (after the fact, the code base updated orders incorrectly, I was told we don't want audit tables beforehand, now they are desperate) be careful with logminer, it's not intuitively obvious which statement is the one you want to recover and, if you do a lot of data refresh (we do a daily truncate and reload of a catalog schema) can give you LOTS of records to go through -- in our case, 11 million records in two days of logs --- Robson, Peter [EMAIL PROTECTED] wrote: Hi Listers, I have little problem : Hmmm, that may not be a little problem at all how to undelete record that we've delete and commit so I can restore again in my data, thanks a lot. You can resort to conventional Oracle backup and recovery (other folk will tell you all about that). But if you have important data tables, you can audit them individually. We have. We also have people who are liable to do just this sort of thing. Using our auditing approach, we can recover immediately, even after a commit. Requires an audit table for each data table, with a pre-change trigger to capture each row before the DML statement. More details if you wish (after Christmas - I'm off!) peter edinburgh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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).
RE: Undelete Record
You can't depend on Flashback query for recovery. Even if the undo entries are not overwritten, there is a hard limit of retention. The maximum retention period is 5 days. Actually, the data could be retained for longer, but the SCN - Time map that allows for flashing back has a 5 day limit. -Original Message- Sent: Friday, December 20, 2002 8:35 AM To: Multiple recipients of list ORACLE-L and if they caught the problem within the retention time and if there wasn't a lot of activity that would cause Oracle to overwrite the undo segment anyway... and and and while I like the idea of flashback query, I'd hate to depend on it for data recovery. --- Deshpande, Kirti [EMAIL PROTECTED] wrote: If it is Oracle9i and AUM is in use and UNDO_RETENTION is set up properly, then flashback query can be the answer... - Kirti -Original Message- Sent: Friday, December 20, 2002 5:04 AM To: Multiple recipients of list ORACLE-L the audit table works well, I've used it before and am implementing it now (after the fact, the code base updated orders incorrectly, I was told we don't want audit tables beforehand, now they are desperate) be careful with logminer, it's not intuitively obvious which statement is the one you want to recover and, if you do a lot of data refresh (we do a daily truncate and reload of a catalog schema) can give you LOTS of records to go through -- in our case, 11 million records in two days of logs --- Robson, Peter [EMAIL PROTECTED] wrote: Hi Listers, I have little problem : Hmmm, that may not be a little problem at all how to undelete record that we've delete and commit so I can restore again in my data, thanks a lot. You can resort to conventional Oracle backup and recovery (other folk will tell you all about that). But if you have important data tables, you can audit them individually. We have. We also have people who are liable to do just this sort of thing. Using our auditing approach, we can recover immediately, even after a commit. Requires an audit table for each data table, with a pre-change trigger to capture each row before the DML statement. More details if you wish (after Christmas - I'm off!) peter edinburgh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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.net -- Author: Fink, Dan 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).
RE: Undelete Record
Yes, I am aware of this hard limit (and how smon_scn_time table is maintained by Oracle ;) FBQ has its limitations. And it has some benefits. For an accidental mess up that is realized soon enough, FBQ may help. - Kirti -Original Message- Sent: Friday, December 20, 2002 10:55 AM To: Multiple recipients of list ORACLE-L You can't depend on Flashback query for recovery. Even if the undo entries are not overwritten, there is a hard limit of retention. The maximum retention period is 5 days. Actually, the data could be retained for longer, but the SCN - Time map that allows for flashing back has a 5 day limit. -Original Message- Sent: Friday, December 20, 2002 8:35 AM To: Multiple recipients of list ORACLE-L and if they caught the problem within the retention time and if there wasn't a lot of activity that would cause Oracle to overwrite the undo segment anyway... and and and while I like the idea of flashback query, I'd hate to depend on it for data recovery. --- Deshpande, Kirti [EMAIL PROTECTED] wrote: If it is Oracle9i and AUM is in use and UNDO_RETENTION is set up properly, then flashback query can be the answer... - Kirti -Original Message- Sent: Friday, December 20, 2002 5:04 AM To: Multiple recipients of list ORACLE-L the audit table works well, I've used it before and am implementing it now (after the fact, the code base updated orders incorrectly, I was told we don't want audit tables beforehand, now they are desperate) be careful with logminer, it's not intuitively obvious which statement is the one you want to recover and, if you do a lot of data refresh (we do a daily truncate and reload of a catalog schema) can give you LOTS of records to go through -- in our case, 11 million records in two days of logs --- Robson, Peter [EMAIL PROTECTED] wrote: Hi Listers, I have little problem : Hmmm, that may not be a little problem at all how to undelete record that we've delete and commit so I can restore again in my data, thanks a lot. You can resort to conventional Oracle backup and recovery (other folk will tell you all about that). But if you have important data tables, you can audit them individually. We have. We also have people who are liable to do just this sort of thing. Using our auditing approach, we can recover immediately, even after a commit. Requires an audit table for each data table, with a pre-change trigger to capture each row before the DML statement. More details if you wish (after Christmas - I'm off!) peter edinburgh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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).
RE: Undelete Record
But by the way Kirti, would you like to give me a script what flashback query looks like ? honestly I never use it. Thanks - Sony -Original Message- From: Deshpande, Kirti [SMTP:[EMAIL PROTECTED]] Sent: Friday, December 20, 2002 8:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: Undelete Record If it is Oracle9i and AUM is in use and UNDO_RETENTION is set up properly, then flashback query can be the answer... - Kirti -Original Message- Sent: Friday, December 20, 2002 5:04 AM To: Multiple recipients of list ORACLE-L the audit table works well, I've used it before and am implementing it now (after the fact, the code base updated orders incorrectly, I was told we don't want audit tables beforehand, now they are desperate) be careful with logminer, it's not intuitively obvious which statement is the one you want to recover and, if you do a lot of data refresh (we do a daily truncate and reload of a catalog schema) can give you LOTS of records to go through -- in our case, 11 million records in two days of logs --- Robson, Peter [EMAIL PROTECTED] wrote: Hi Listers, I have little problem : Hmmm, that may not be a little problem at all how to undelete record that we've delete and commit so I can restore again in my data, thanks a lot. You can resort to conventional Oracle backup and recovery (other folk will tell you all about that). But if you have important data tables, you can audit them individually. We have. We also have people who are liable to do just this sort of thing. Using our auditing approach, we can recover immediately, even after a commit. Requires an audit table for each data table, with a pre-change trigger to capture each row before the DML statement. More details if you wish (after Christmas - I'm off!) peter edinburgh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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.net -- Author: Sony kristanto 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).
RE: Undelete Record
If you have access to Metalink, I suggest reviewing Note# 174425.1. It will show how this feature works in Oracle9i Release 1. - Kirti -Original Message- Sent: Friday, December 20, 2002 7:54 PM To: Multiple recipients of list ORACLE-L But by the way Kirti, would you like to give me a script what flashback query looks like ? honestly I never use it. Thanks - Sony -Original Message- From: Deshpande, Kirti [SMTP:[EMAIL PROTECTED]] Sent: Friday, December 20, 2002 8:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: Undelete Record If it is Oracle9i and AUM is in use and UNDO_RETENTION is set up properly, then flashback query can be the answer... - Kirti -Original Message- Sent: Friday, December 20, 2002 5:04 AM To: Multiple recipients of list ORACLE-L the audit table works well, I've used it before and am implementing it now (after the fact, the code base updated orders incorrectly, I was told we don't want audit tables beforehand, now they are desperate) be careful with logminer, it's not intuitively obvious which statement is the one you want to recover and, if you do a lot of data refresh (we do a daily truncate and reload of a catalog schema) can give you LOTS of records to go through -- in our case, 11 million records in two days of logs --- Robson, Peter [EMAIL PROTECTED] wrote: Hi Listers, I have little problem : Hmmm, that may not be a little problem at all how to undelete record that we've delete and commit so I can restore again in my data, thanks a lot. You can resort to conventional Oracle backup and recovery (other folk will tell you all about that). But if you have important data tables, you can audit them individually. We have. We also have people who are liable to do just this sort of thing. Using our auditing approach, we can recover immediately, even after a commit. Requires an audit table for each data table, with a pre-change trigger to capture each row before the DML statement. More details if you wish (after Christmas - I'm off!) peter edinburgh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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).
