Re: SV: Date Format: Mystery
Hi, From Note: 69028.1 on Metalink The datatype returned is 13 and not 12, the external DATE datatype. This occurs because we rely on the TO_DATE function! External datatype 13 is an internal c-structure whose length varies depending on how the c-compiler represents the structure. Note that the Len= value is 8 and not 7. Type 13 is not a part of the published 3GL interfaces for Oracle and is used for date calculations mainly within PL/SQL operations. Note that the same result can be seen when DUMPing the value SYSDATE. Garry Gillies Database Administrator Business Systems Weir Pumps Ltd 149 Newlands Road, Cathcart, Glasgow, G44 4EX T: +44 0141 308 3982 F: +44 0141 633 1147 E: [EMAIL PROTECTED] Jonathan Gennick [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L .com [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Re: SV: Date Format: Mystery .com 30/01/04 13:44 Please respond to ORACLE-L Friday, January 30, 2004, 2:24:25 AM, Jesper Haure Norrevang ([EMAIL PROTECTED]) wrote: JHN Certainly som conversion is going on here. This might be the reason why JHN there has been confusion about 7 or 8 bytes in a DATE datatype. That's really interesting, that switch between 7 and 8 bytes. Oracle's docs, I believe in the OCI manual, do show a seven-byte format. JHN To answer your question, it is possible to deal with fractions of seconds, JHN byt you need to use the TIMESTAMP datatype. The function SYSTIMESTAMP could JHN be useful. Be aware that Oracle supports 9 decimals, but not all hardware JHN platforms do. Related to this, just because a platform returns, say, six digits, does not mean it increments on that last digit. Instead of: 21.01 seconds 21.02 seconds ... The best your platform does might look like: 21.01 seconds 21.000801 seconds 21.001601 seconds ... I just made these numbers up, but hopefully they give the idea. I'm still curious about that seven versus eight byte thing with SYSDATE. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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). CONFIDENTIAL: The information contained in this email (including any attachments) is confidential, subject to copyright and for the use of the intended recipient only. If you are not the intended recipient please delete this message after notifying the sender. Unauthorised retention, alteration or distribution of this email is forbidden and may be actionable. Attachments are opened at your own risk and you are advised to scan incoming email for viruses before opening any attached files. We give no guarantee that any communication is virus-free and accept no responsibility for virus contamination or other system loss or damage
Re: Can I execute an exe from a stored Procedure
Try Metalink Note 222079.1 How to Perform a System Call From a Java Stored Procedure and capture the output. Garry Gillies Database Administrator Business Systems Weir Pumps Ltd 149 Newlands Road, Cathcart, Glasgow, G44 4EX T: +44 0141 308 3982 F: +44 0141 633 1147 E: [EMAIL PROTECTED] [EMAIL PROTECTED] (Jake Johnson) Sent by: [EMAIL PROTECTED] 06/10/03 23:34 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Can I execute an exe from a stored Procedure Hello, Is it possible to execute an exe from a stored procedure? If so can you please provide an exmple? Thanks Jake -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jake Johnson 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). CONFIDENTIAL: The information contained in this email (including any attachments) is confidential, subject to copyright and for the use of the intended recipient only. If you are not the intended recipient please delete this message after notifying the sender. Unauthorised retention, alteration or distribution of this email is forbidden and may be actionable. Attachments are opened at your own risk and you are advised to scan incoming email for viruses before opening any attached files. We give no guarantee that any communication is virus-free and accept no responsibility for virus contamination or other system loss or damage of any kind. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Garry Gillies 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: Physical I/O and databases other than oracle
Im reading an academic book on databases and it states that Physical I/O is often the primary bottleneck in tuning. Its not the case in Oracle. Is this statement correct with sybase, sql server, or DB2? or maybe mysql? Eh? What IS the primary bottleneck in tuning Oracle? I go along with Jonathan Lewis in his book Practical Oracle 8i Although it is possible to create a few problems with network traffic, excess CPU usage and process contention, ultimately the only significant threat to a database system is physical I/O. (page 38) CONFIDENTIAL: The information contained in this email (including any attachments) is confidential, subject to copyright and for the use of the intended recipient only. If you are not the intended recipient please delete this message after notifying the sender. Unauthorised retention, alteration or distribution of this email is forbidden and may be actionable. Attachments are opened at your own risk and you are advised to scan incoming email for viruses before opening any attached files. We give no guarantee that any communication is virus-free and accept no responsibility for virus contamination or other system loss or damage of any kind. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Garry Gillies 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).
cron.next_date - was DBMS_JOB scheduling
Package can be obtained from http://oracledba.pwp.blueyonder.co.uk/cron.html Use at your own risk. Garry Gillies CONFIDENTIAL: The information contained in this email (including any attachments) is confidential, subject to copyright and for the use of the intended recipient only. If you are not the intended recipient please delete this message after notifying the sender. Unauthorised retention, alteration or distribution of this email is forbidden and may be actionable. Attachments are opened at your own risk and you are advised to scan incoming email for viruses before opening any attached files. We give no guarantee that any communication is virus-free and accept no responsibility for virus contamination or other system loss or damage of any kind. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Garry Gillies 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).
DBMS_JOB scheduling
Any Interest? The DBMS_JOB package is supplied by Oracle to allow the running of procedures at regular intervals. Unfortunately the INTERVAL parameter is limited to 128 characters, which prevents you from getting very complex (user defined functions [in the interval parameter] do not work well - according to Fuerstein in his book Oracle Built In Packages). The situation is eased somewhat by the fact that the NEXT_DATE parameter can be supplied to the procedure as an in/out parameter - and the procedure can contain whatever code is necessary to calculate when next to run. This is all very well, but custom coding scheduling routines can quickly become tedious. On the basis of do it once and get it over with I have written a function called NEXT_DATE which I have wrapped in a package called CRON. There is a Unix program called cron which runs jobs on a regular basis. Although the scheduling data supplied to cron is simple and concise, complex schedules are easy to specify. The NEXT_DATE function takes in a cron schedule string and returns the next date that conforms to the schedule - or you can supply a cron schedule and a date and it will return the first date after the supplied date that conforms to the schedule. At the moment it is not very friendly on the error detection front. A VALUE_ERROR is returned if it deems the cron schedule to be invalid. You will also get a VALUE_ERROR if the next valid date is more than twenty seven years in the future. DBMS_OUTPUT is used to display error messages which will hopefully give you a clue. This will be improved if I receive enough complaints ( and suggestions for improvements). THE CRON SCHEDULE A cron schedule consists of five components, each separated from the next by a space. The syntax is identical for all components. The components represent Minute in Hour Hour in day Day in month Month in year Day of Week - A bit of a bugger this one. In Unix land the day numbering runs from 0-6 with 0 being Sunday. In Oracle the day numbering depends on the setting of NLS_TERRITORY. I have chosen to go with ISO standard 8601:1998 which runs from 1-7 with 1 being Monday. This is so close to the Unix convention that I can interpret Unix cron schedules correctly. Curiously, Oracle do not provide a date format which supplies this number. The ISO week number is available with the format 'IW', but not the ISO day number. If you have a field of type date called dt, you can obtain the ISO day number with ( trunc(dt) - trunc(dt ,'IW') ) + 1 A component can consist of an asterisk *which represents all valid values or a number of elements separated by a comma (if only one element is supplied, forget the comma). An element can be a single number - valid for the component (32 in Day in month is invalid) or two numbers separated by a hyphen - which represents a range. EXAMPLES Run every hour on the hour 0 * * * * Run twice every hour, on the hour and on the half hour 0,30 * * * * Run twice every hour, on the hour and on the half hour between 08:00 and 16:59 0,30 8-16 * * * Run twice every hour, on the hour and on the half hour between 08:00 and 16:59, Monday to Friday 0,30 8-16 * * 1-5 Run at 11:12 every Friday the 13th 11 12 13 * 5 Run at 04:00 every leap year on february 29 0 4 29 2 * Run at 04:00 every leap year on february 29 when february 29 is a Thursday 0 4 29 2 4 Garry Gillies Database Administrator Business Systems Weir Pumps Ltd 149 Newlands Road, Cathcart, Glasgow, G44 4EX T: +44 0141 308 3982 F: +44 0141 633 1147 E: [EMAIL PROTECTED] CONFIDENTIAL: The information contained in this email (including any attachments) is confidential, subject to copyright and for the use of the intended recipient only. If you are not the intended recipient please delete this message after notifying the sender. Unauthorised retention, alteration or distribution of this email is forbidden and may be actionable. Attachments are opened at your own risk and you are advised to scan incoming email for viruses before opening any attached files. We give no guarantee that any communication is virus-free and accept no responsibility for virus contamination or other system loss or damage of any kind. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Garry Gillies 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
RE: DBMS_JOB scheduling
1. have you tried select to_char(sysdate,'D') from dual ?? Yes, and it works fine on MY servers, but the docs say that the value returned depends on your NLS_TERRITORY setting. I am trying to get it to work for everybody. This is really nice, but my only gripe with dbms-job is that is isn't reliable ... it wasn't in 9ir1 on aix and we didn't even look at it in 9ir2. in 9ir1 dbms_job used to _forget_ to run jobs after some time and the workaround was like setting job_processes to a very large number. I am sorry to hear that. We are on 8.1.7 and have been using since 7.3 with no major problems. nevertheless, I think what you have attempted is fantastic and worthy of adoption ... Are you looking for money? :-) Garry Gillies Database Administrator Business Systems Weir Pumps Ltd 149 Newlands Road, Cathcart, Glasgow, G44 4EX T: +44 0141 308 3982 F: +44 0141 633 1147 E: [EMAIL PROTECTED] Jamadagni, Rajendra [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 23/07/03 15:24 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: DBMS_JOB scheduling Garry, 1. have you tried select to_char(sysdate,'D') from dual ?? This is really nice, but my only gripe with dbms-job is that is isn't reliable ... it wasn't in 9ir1 on aix and we didn't even look at it in 9ir2. in 9ir1 dbms_job used to _forget_ to run jobs after some time and the workaround was like setting job_processes to a very large number. nevertheless, I think what you have attempted is fantastic and worthy of adoption ... CONFIDENTIAL: The information contained in this email (including any attachments) is confidential, subject to copyright and for the use of the intended recipient only. If you are not the intended recipient please delete this message after notifying the sender. Unauthorised retention, alteration or distribution of this email is forbidden and may be actionable. Attachments are opened at your own risk and you are advised to scan incoming email for viruses before opening any attached files. We give no guarantee that any communication is virus-free and accept no responsibility for virus contamination or other system loss or damage of any kind. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Garry Gillies 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: ORA-29540: class oracle/plsql/net/TCPConnection does not exist
Hi Nirmal, I believe there is a bug in the installer and the following two steps are missing cd $ORACLE_HOME/plsql/jlib loadjava -user sys/sys_password plsql.jar Do them yourself manually and you should be fine. Hope this helps Garry Gillies Database Administrator Business Systems Weir Pumps Ltd 149 Newlands Road, Cathcart, Glasgow, G44 4EX T: +44 0141 308 3982 F: +44 0141 633 1147 E: [EMAIL PROTECTED] Nirmal Kumar M [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 20/07/03 17:49 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:ORA-29540: class oracle/plsql/net/TCPConnection does not exist Helo all, I have installed oracle JVM on oracle817, windows2000. Asper the doc from metalink, i installed it sucessfully. When i'm using the utl_smtp package from the client forms6i, the error ORA-29540: class oracle/plsql/net/TCPConnection does not exist raised out. How to proceed next?. installation steps: 1) resource configuration, rollback segment, shared pool, java pool, system tablespace has been done. 2) connect internal, run script initjvm.sql i verified post installation steps, my results matched with the document note from metalink installing jvm on oracle817. Thanks. Nirmal, = fsdfsdfsdfsdfs __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nirmal Kumar M 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). CONFIDENTIAL: The information contained in this email (including any attachments) is confidential, subject to copyright and for the use of the intended recipient only. If you are not the intended recipient please delete this message after notifying the sender. Unauthorised retention, alteration or distribution of this email is forbidden and may be actionable. Attachments are opened at your own risk and you are advised to scan incoming email for viruses before opening any attached files. We give no guarantee that any communication is virus-free and accept no responsibility for virus contamination or other system loss or damage of any kind. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Garry Gillies 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: OT: unix shell script question
Try DBNAME=PROD LINE_PROD=100 CMD=echo \$LINE_$DBNAME echo $CMD eval $CMD Dilip [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 15/07/03 11:34 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:OT: unix shell script question Hi List, The requirement is as follows: DBNAME=PROD ( 'DBNAME' variable contains value 'PROD' ) LINE_PROD=100 ( 'LINE_PROD' variable contains value 100 ) Now I want to echo the LINE_PROD variable using DBNAME variable. e.g echo ${LINE_${DBNAME}} should return 100. Is this possible and if yes, how ? I tried some ways but couldn't find any way. Regards, ~Dilip CONFIDENTIAL: The information contained in this email (including any attachments) is confidential, subject to copyright and for the use of the intended recipient only. If you are not the intended recipient please delete this message after notifying the sender. Unauthorised retention, alteration or distribution of this email is forbidden and may be actionable. Attachments are opened at your own risk and you are advised to scan incoming email for viruses before opening any attached files. We give no guarantee that any communication is virus-free and accept no responsibility for virus contamination or other system loss or damage of any kind. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Garry Gillies 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: should you seperate indexes from tables in seperate datafiles?
It's hot here. I wish I was at the beach and I feel like a rant. oracle actually accesses indexes and tables serially Is it just me or is this blindingly obvious? You cannot access the table data until you have completed accessing the index data because the index data contains the location of the table data. During an indexed query on a single table the index will be accessed, then the table, then the index,then the table, then the index,then the table then the index,then the table. If the index and the table are on the same disk then a lot of time will be taken up by head seek movement. If they are on the different disks then the index heads can locate their data and stay there - and the data heads can locate their data and stay there. Less head movement, less wasted time. That is the argument for what it is worth. Real life is of course vastly more complex than this and we are swimming in very muddy waters, which is why there is so much argument on the subject (raid salesmen - spit). Thanks for the vent Garry Gillies [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 15/07/03 15:49 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:should you seperate indexes from tables in seperate datafiles? There has been alot of literature stating that you will recieve performance improvements by seperating indexes and tables across multiple I/O points. Ie... you have a tables tablespace and an index tablespace. If you put them on seperate hard drives, you will have less I/O contention. Now Im seeing some articles stating that this is not true. That oracle actually accesses indexes and tables serially. Now it might be useful seperate indexes from tables for maintenance purposes but this wont lower I/O contention. Can anyone chime in on this? Curious to see where the evidence is leading? CONFIDENTIAL: The information contained in this email (including any attachments) is confidential, subject to copyright and for the use of the intended recipient only. If you are not the intended recipient please delete this message after notifying the sender. Unauthorised retention, alteration or distribution of this email is forbidden and may be actionable. Attachments are opened at your own risk and you are advised to scan incoming email for viruses before opening any attached files. We give no guarantee that any communication is virus-free and accept no responsibility for virus contamination or other system loss or damage of any kind. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Garry Gillies 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).
PLS-00907: cannot load library unit
RDBMS 8.1.7.4 on Sun Sparc Solaris 5.8 Package USR1.PACKAGE1 on DB1 references USR2.PACKAGE2 on DB2, which in turn references USR2.PACKAGE3 on DB2. Sometimes the package body of PACKAGE1 refuses to compile, giving the error PLS-00907: cannot load library unit [EMAIL PROTECTED] (referenced by [EMAIL PROTECTED]) Bouncing database DB1 fixes the problem (until the next time). Any ideas anyone? Thanks for your time Garry Gillies -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Garry Gillies 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: Snapshot too old during stress test... how to avoid
From memory (of a course attended looong ago), Oracle recommends one rollback segment for every three to four users. Four rollback segments between thirty six processes does seem a little mean. Garry [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/06/03 13:59 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Snapshot too old during stress test... how to avoid Im testing worst case scenarios right now. So Im doing batch updates,inserts,deletes and 'create table as' from a staging tablespace of approximately 5GBs to a master tablespace of approximately 11GBs. Ive got my job queue processes set to 36 and Im running 36 at a time in the background in order to gather statistics and timing under worst case scenarios. Im in 8.1.7.3 and I have increased the size of my RBS tablespace to 11GB for this test. I have 4 standard RBS with optimal size set to 1GB. Why would I get a snapshot too old? I would think that 11GBs of rollback would be big enough. Would increasing the number of Rollback segments avoid this even though I have the same amount of space in the tablespace? In reality Im going to seriallize the process to avoid this and to improve performance, however, I want to stress the system. any advice? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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: Garry Gillies 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).