Re: HOW TO MAKE DELETION FAST
This is one of the reasons for using partitions. Instead of deleting millions of rows from a large table, you drop the partition containing the data to be deleted. PST Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> cc: Hi I want to delete milliuns of row from one table.that table have 2 constraints and some indexes.What to do for fast deletion.When ever I run deletion it takes time too. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Mike J Kurth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: HOW TO MAKE DELETION FAST
Hi, Seema, I f the issue is still current, deletions taking too much time may be caused by not indexed foreign keys. If the child table does not have an index on a column which references the parent one, to delete even a single row Oracle performs full table scan which locks the table, too. It is a serious issue when tables are huge. So I'd check for unindexed foreign keys first. Regards, Sergey Babich -Original Message- Sent: Thursday, January 10, 2002 6:05 PM To: Multiple recipients of list ORACLE-L Subject:HOW TO MAKE DELETION FAST Hi I want to delete milliuns of row from one table.that table have 2 constraints and some indexes.What to do for fast deletion.When ever I run deletion it takes time too. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Babich , Sergey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: HOW TO MAKE DELETION FAST
If TRUNCATE is not possible, then disable the constraints, put database in no archive log mode and delete. It should run fast. Or alter the table to be nologgin. After deletion, rebuild the indexes and analyze both tables and indexes. -Original Message- Sent: Thursday, January 10, 2002 3:05 PM To: Multiple recipients of list ORACLE-L Hi I want to delete milliuns of row from one table.that table have 2 constraints and some indexes.What to do for fast deletion.When ever I run deletion it takes time too. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: HOW TO MAKE DELETION FAST
Seema, Deletions use lots of rollback space and generate lots of redo. And if there are indexes and constraints its going to prolong the transaction. Depend on the number of records being deleted and availability of space. It is better to recreate the table without the records that are to be deleted. Then drop the original table, rename old table to the new 1, and recreating the indexes, triggers and constraints that were present b4. ** Just be careful with this approach though cause u need to know what u really doing. Regards Suhen Hi I want to delete milliuns of row from one table.that table have 2 constraints and some indexes.What to do for fast deletion.When ever I run deletion it takes time too. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: HOW TO MAKE DELETION FAST
Hi, Disabling of Primary keys and other indexes will make your deletions faster . HTH shreepad -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: HOW TO MAKE DELETION FAST
indexes, yea, constraints, possibly. making sure the disk(s) holding the datafile(s) holding the index extent(s) were as quiet as possible? Yes Using parallel execution (in the case the delete has a WHERE clause ) Yes... Peforming the delete while the database server was relatively quiet? Yes "Every little bit helps" hth, Ross -Original Message- Sent: Thursday, December 27, 2001 5:01 PM To: Multiple recipients of list ORACLE-L Would dropping indexes and (if applicable) disabling constraints on the table, before deleting help ?? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: HOW TO MAKE DELETION FAST
Would dropping indexes and (if applicable) disabling constraints on the table, before deleting help ?? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
RE: HOW TO MAKE DELETION FAST
Stephen, I agree with everything you suggested except #3 -- if he is deleting that many rows, Oracle will ignore the indexes and will full table scan the delete anyway. Last I heard (from Oracle University) was that if Oracle expects more than 5-8% of the table to return from the query, it will do a full table scan no matter what Rachel --- "Karniotis, Stephen" <[EMAIL PROTECTED]> wrote: > OK. Everyone is assuming that your deletion of millions of rows may > be > expedited by simply truncating the table. Now, that would be perfect > if you > were simply emptying the table. However, if data is to remain in the > table, > then truncate is not the preferred choice. Here are some options > along with > some cautions. > > 1. PL/SQL procedure to perform delete - If you are deleting data > based on > values in another table, you could use a DELETE with a correlated > sub-query > to delete data. You could also add a counter to the PL/SQL code to > delete > 50,000 rows, commit the deletion and then continue. Unfortunately, > if you > make a mistake with the DELETE, you must recover the table from > Offline > archivedlogs. PL/SQL has never been the preferred choice for working > with > LOTS of data. > 2. CTAS - Create Table as SELECT is another alternative. If you can > create > another table with only the data you want, delete the original table > and > simply rename this new table to the old name, you may speed up the > process. > Additionally, creating the table as UNRECOVERABLE helps as it reduces > the > amount of redo data generated by Oracle. > 3. Use indexes with the delete process - If your delete process is > referencing non-indexed columns, you are performing a full table scan > for > the DELETE. Using indexes will help performance significantly > because the > amount of data scanned is significantly reduced. > 4. Traditional DELETE wit subquery - Same as PL/SQL offering except > you > cannot control the amount of data deleted between commits. > > These are four options. Good luck. > > Thank You > > Stephen P. Karniotis > Technical Alliance Manager > Compuware Corporation > Direct: (248) 865-4350 > Mobile: (248) 408-2918 > Email:[EMAIL PROTECTED] > Web: www.compuware.com > > > -Original Message- > Sent: Thursday, December 27, 2001 3:15 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: HOW TO MAKE DELETION FAST > > TRUNCATE TABLE :-) > > > -Original Message- > Sent: Thursday, December 27, 2001 3:00 PM > To: Multiple recipients of list ORACLE-L > > > Hi Gurus > How to make deletetion of millions rows faster? > Please suggest. > Thx > Seema > > > > _ > Join the world's largest e-mail service with MSN Hotmail. > http://www.hotmail.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Seema Singh > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > 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 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > 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: Karniotis, Stephen > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, se
RE: HOW TO MAKE DELETION FAST
Title: RE: HOW TO MAKE DELETION FAST If you have indexes on the table you may want to drop prior to delete and rebuild them after it completes. Does this table have foreign key constraints? Rowid is the fastest data access method. Create a interim table of the rowids for the rows you want deleted and delete from table where rowid in interim table rowid column. You may want to lock the table if you are worried about row migration. -Original Message- Sent: Thursday, December 27, 2001 3:00 PM To: Multiple recipients of list ORACLE-L Hi Gurus How to make deletetion of millions rows faster? Please suggest. Thx Seema _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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: HOW TO MAKE DELETION FAST
OK. Everyone is assuming that your deletion of millions of rows may be expedited by simply truncating the table. Now, that would be perfect if you were simply emptying the table. However, if data is to remain in the table, then truncate is not the preferred choice. Here are some options along with some cautions. 1. PL/SQL procedure to perform delete - If you are deleting data based on values in another table, you could use a DELETE with a correlated sub-query to delete data. You could also add a counter to the PL/SQL code to delete 50,000 rows, commit the deletion and then continue. Unfortunately, if you make a mistake with the DELETE, you must recover the table from Offline archivedlogs. PL/SQL has never been the preferred choice for working with LOTS of data. 2. CTAS - Create Table as SELECT is another alternative. If you can create another table with only the data you want, delete the original table and simply rename this new table to the old name, you may speed up the process. Additionally, creating the table as UNRECOVERABLE helps as it reduces the amount of redo data generated by Oracle. 3. Use indexes with the delete process - If your delete process is referencing non-indexed columns, you are performing a full table scan for the DELETE. Using indexes will help performance significantly because the amount of data scanned is significantly reduced. 4. Traditional DELETE wit subquery - Same as PL/SQL offering except you cannot control the amount of data deleted between commits. These are four options. Good luck. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Thursday, December 27, 2001 3:15 PM To: Multiple recipients of list ORACLE-L Subject:RE: HOW TO MAKE DELETION FAST TRUNCATE TABLE :-) -Original Message- Sent: Thursday, December 27, 2001 3:00 PM To: Multiple recipients of list ORACLE-L Hi Gurus How to make deletetion of millions rows faster? Please suggest. Thx Seema _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: HOW TO MAKE DELETION FAST
how many rows are left? or what is the percentage of rows will be deleted? -Original Message- Sent: Thursday, December 27, 2001 3:00 PM To: Multiple recipients of list ORACLE-L Hi Gurus How to make deletetion of millions rows faster? Please suggest. Thx Seema _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: HOW TO MAKE DELETION FAST
Seema, You did not say how many rows you wanted to keep. If the number is small then I would create a table as select.. nologging. and populate it with the rows you want to keep. Then truncate the original table and repopulate it with the rows you saved in the secondary table. This way the HWM gets reset and and frees up the space not used anymore. ROR mª¿ªm >>> [EMAIL PROTECTED] 12/27/01 03:00PM >>> Hi Gurus How to make deletetion of millions rows faster? Please suggest. Thx Seema _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: HOW TO MAKE DELETION FAST
TRUNCATE TABLE :-) -Original Message- Sent: Thursday, December 27, 2001 3:00 PM To: Multiple recipients of list ORACLE-L Hi Gurus How to make deletetion of millions rows faster? Please suggest. Thx Seema _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: HOW TO MAKE DELETION FAST
If you do not need to log the deletions, truncate the table, then coalesce the tablespace in question. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 27, 2001 3:00 PM To: Multiple recipients of list ORACLE-L Hi Gurus How to make deletetion of millions rows faster? Please suggest. Thx Seema _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).