Re: RAC or Oracle Fail Safe
Title: RE: RAC or Oracle Fail Safe Hi! Of course you have to plan your servers' capacity accordingly, that in the event of node failure, the other node will not get too loaded. When one node crashes, the second one has to deal with queries and transactions of both servers and we must not forget, that also rollback of failed nodes uncommitted transactions has to be done! Of course when you got more nodes, then the impact of one node failure would be smaller.. Tanel. Here I would beg to differ. RAC is more safe. _Almost_ half of your online user (who are on surviving node) wont even notice the node failure when one node in a RAC environment goes down. And those who were unlucky users (connected to failed node), can connect immediately to the surviving node, without any delay. Of course you need to configure these parameters manually. While in OFS environment your users have to wait till the time surviving node brings up the database and all related services (listener etc) completely. The price you may for these features is more money and more complex database environment to manage.
Re: imp table data, but not PK indexes?
Hi! Yes, but IIRC CONSTRAINTS=Y is an exp parameter, not imp? It's imp parameter as well. Best way to handle these things is to export twice. Once with all the bells and whistles turned on but ROWS=N (this gives you a small export file with all the schema logic added and takes no time at all). The next one is with CONSTRAINTS=N, ROWS=Y, INDEXES=N, DIRECT=Y. This one is used for bulk data load. I'd go that way: 1) export schema structure with rows=n 2) export data with constraints=n rows=y indexes=n direct=y recordlength=65535 3) import structure file w. indexes=n constraints=n 4) import data file w. buffer=high value (constraints=n and indexes=n don't have to specified if export was set not to export them) 5) import structure file w. constraints=y indexes=y indexfile=indexfile.sql (nothing is actually imported, we just get constraint indexes and excplicit indexes DDL statements into text file) 6) modify indexfile.sql and add nologging + possibly parallel clauses to your DDL statements. Also you might want to alter session set db_file_multiblock_read_count and sort_area_size to larger values in beginning of your script. 7) import your data file, with buffer=big value 8) run your indexfile.sql script 9) import structure file again with constraints=y indexes=n and ignore=y Note that indexfile created in step 5 will contain only non-system-generated indexes! (you can check generated field in dba_indexes to see which are system generated ones). Thus, indexes which are implicitly created using primary and unique keys, won't show up in indexfile. But that doesn't kill us - imp with constraints=y will eventually create these indexes anyway, we just can't control the DDL command issued for them (you might want to set tablespaces storing these indexes NOLOGGING temporarily during their creation). Also, if you plan to shorten your downtime by first exporting/importing the structure from online database and then transferring data during downtime, you have to worry about your sequences, because they have probably incremented after structure export and data export. Thus a simple script has to be done for that (thanks John ;). Tanel. With these two exports, one can do just about any manipulation needed. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto 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: Tanel Poder 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: imp table data, but not PK indexes?
- Original Message - 2) export data with constraints=n rows=y indexes=n direct=y recordlength=65535 ^^ Do you find that makes a real difference? I haven't had much success with it... Also, if you plan to shorten your downtime by first exporting/importing the structure from online database and then transferring data during downtime, you have to worry about your sequences, because they have probably incremented after structure export and data export. Thus a simple script has to be done for that (thanks John ;). Good point, thanx! Tanel. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto 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).
RAID select
Hi I have a DB server with RAID-1 and RAID-0+1 (There is no RAID-0). Also the NON-RAID diska are available. I have the tablespaces as: SYSTEM USERS01(Heavily Accessd) RWEBCONFIG(Less Accessed) RTRADE(Less Accessed) INDEX01(Heavily Accessd) INDEX02(Heavily Accessd) RBS01 RBS02 TEMP STAT(For PERFSTAT) What could be a suitable configuration for the datafiles under these tablespaces across the available RAIDs. Also where the backups and archive_dest should be. Can anybody give me some tips on this Thanks and Regards ___ Download the hottest happening ringtones here! OR SMS: Top tone to 7333 Click here now: http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan 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).
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).
Different Platform
Hi All Our production environment is on Sun OS 5.8 sparc. DB is Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production PL/SQL Release 8.1.7.0.0 - Production CORE 8.1.7.0.0 Production TNS for Solaris: Version 8.1.7.0.0 - Production NLSRTL Version 3.4.1.0.0 - Production The application has a lot of Pro*C programs. -- We are planning to have the development/test DB on Linux 2.4 on Intel platform. We will be doing modifications/upgrades to the application and DB and will be applying the changes to production. Will there be ANY kind of compatibility problem (relating to OCI, or plsql procs etc) ? Thanks in Advance Regards ___ Download the hottest happening ringtones here! OR SMS: Top tone to 7333 Click here now: http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan 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).
DB shift
Hi All We are planning to Shift our Db to a new hardware(having RAIDs). The OS is exactly same on both the servers. Presently Oracle Version is 8.1.7.0.0 In the new server Oracle 8.1.7.4 is installed. What I am planning is to Shift the DB by copying the data files from old to new server. Renaming them in mount stage if required. For the Oracle version change (upgrade) will there be any problem? So that export/import will be the only option. Thanks for your valuable input. Regards ___ Download the hottest happening ringtones here! OR SMS: Top tone to 7333 Click here now: http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan 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: Different Platform
Hi! Our production environment is on Sun OS 5.8 sparc. [snip] The application has a lot of Pro*C programs. -- We are planning to have the development/test DB on Linux 2.4 on Intel platform. We will be doing modifications/upgrades to the application and DB and will be applying the changes to production. Will there be ANY kind of compatibility problem (relating to OCI, or plsql procs etc) ? PL/SQL won't usually have any problems, at least I haven't seen any (when moving from unix to unix you won't have thes directory path problems either...). OCI library side should also be the same for all unix platforms, but your application definitely needs to be tested on Sun, there's many differences between platforms, especially when using threading and other advanced programming techniques. Tanel. Thanks in Advance Regards ___ Download the hottest happening ringtones here! OR SMS: Top tone to 7333 Click here now: http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan 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: Tanel Poder 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: imp table data, but not PK indexes?
2) export data with constraints=n rows=y indexes=n direct=y recordlength=65535 ^^ Do you find that makes a real difference? I haven't had much success with it... Never in production. But once I was writing a paper on upgrading databases with low downtime, then I tested this parameter on NT (or was it linux?) workstation and saw difference big enough to conclude, that this parameter may be useful. Tanel. Also, if you plan to shorten your downtime by first exporting/importing the structure from online database and then transferring data during downtime, you have to worry about your sequences, because they have probably incremented after structure export and data export. Thus a simple script has to be done for that (thanks John ;). Good point, thanx! Tanel. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto 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: Tanel Poder 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: DB shift
Hi! When moving to binary compatible platform, you can directly copy over the files (and software). It's even possible with different versions of OS - like from SunOS 2.6 to Solaris 8. For upgrading to 8.1.7.4 follow the patchset readme notes. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, July 20, 2003 7:49 PM Hi All We are planning to Shift our Db to a new hardware(having RAIDs). The OS is exactly same on both the servers. Presently Oracle Version is 8.1.7.0.0 In the new server Oracle 8.1.7.4 is installed. What I am planning is to Shift the DB by copying the data files from old to new server. Renaming them in mount stage if required. For the Oracle version change (upgrade) will there be any problem? So that export/import will be the only option. Thanks for your valuable input. Regards ___ Download the hottest happening ringtones here! OR SMS: Top tone to 7333 Click here now: http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan 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: Tanel Poder 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: Increase tablespace, which way is better?
Hi! Also, there is (or was?) a tradeoff between size and number of datafiles. Before 8i, ifI recall correctly, all datafile headers had to be physicallyvisited (header SCN changes were written) before a checkpoint could finish. If you got thousands of files, this adds significant overhead. Starting from 8i you actually have to do same thing, but with incremenal checkpointing, the datafile headers are updated in groups, thus distributing the jump in IO load over longer period of time. In 6.0, I believe there was no checkpoint process and logwriter was the one responsible updating all file headers. When log buffer was full, all transactions were halt. Others can comment it, because I haven't worked withO 6. Another thing with datafile sizes was recovery in case of corrupt block - it's faster to restore and recover a 1GB file than a 10GB file, but with 9i RMAN block level recovery this problem is relieved as well. And last, a lot of people have had problems with file sizes over 2GB, even in last few years. Some filesystems simply didn't support files over 2GB, others could corrupt the whole file when extended over 2GB (8.1.5 on linux for example). That's why sizes like 1G or 2040 MB were used a lot (by me;) Tanel. "Liu, Jack" [EMAIL PROTECTED] wrote: Hi, I want to increase tablespace, just want to know which way is better:1. ALTER TABLESPACE SYSTEMADD DATAFILE '/u01/oradata/orcl/users02.dbf'SIZE 1MAUTOEXTEND ONNEXT 1MMAXSIZE 100M; 2.alter tablespace system add datafile '/u01/oradata/orcl/users02.dbf' size 100m; Thanks, Jack Yahoo! Mobile- Check compose your email via SMS on your Telstra or Vodafone mobile.
Re: imp table data, but not PK indexes?
I have been using it on HP and it speeds up export with direct=y. I wish HP should enhance this value greater than 65535 as it is maximum limit on HP. It helped me in export when we were changing block size from 4K to 16K Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Sun, 20 Jul 2003 09:14:30 -0800 2) export data with constraints=n rows=y indexes=n direct=y recordlength=65535 ^^ Do you find that makes a real difference? I haven't had much success with it... Never in production. But once I was writing a paper on upgrading databases with low downtime, then I tested this parameter on NT (or was it linux?) workstation and saw difference big enough to conclude, that this parameter may be useful. Tanel. Also, if you plan to shorten your downtime by first exporting/importing the structure from online database and then transferring data during downtime, you have to worry about your sequences, because they have probably incremented after structure export and data export. Thus a simple script has to be done for that (thanks John ;). Good point, thanx! Tanel. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto 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: Tanel Poder 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). _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq 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).
9i - scheduled jobs not running
Hi all, We are working with a third-party ERP system using Oracle databases, and a basic installation of it sets up some default scheduled jobs. We've never had a problem on 8i or 9i on NT, but after a recent 9.2.0.3 install on Solaris 8 we found that none of these jobs would run. They complete successfully if we use DBMS_JOB.SUBMIT and they re-schedule appropriately, but never actually run again. JOB_QUEUE_PROCESSES is set to 9, and I can see the cjq0 process, along with j000 through j004. No errors in the alert log, no trace files anywhere. A co-worker set the hidden parameter _JOB_QUEUE_INTERVAL to 10 and bounced the db, and now the jobs are running correctly. After setting this parameter, I now see five entries for 'jobq slave wait' in v$session_wait, but these did not appear earlier. Any ideas on why this wasn't working before? I thought that in 9i the job queue coordinator default interval was 5 seconds, and that the hidden parameter was only to be used if a smaller interval was needed. Thanks in advance, Beth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Beth Wells 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: DB shift
Hi, I suggest you upgrade your old server from 8170 to 8174 and then copy the datafiles there. Or if downtime is limited, you can use standby database to switch your database from old to new hardware. Regards zhu chao msn:[EMAIL PROTECTED] www.cnoug.org - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 21, 2003 12:49 AM Hi All We are planning to Shift our Db to a new hardware(having RAIDs). The OS is exactly same on both the servers. Presently Oracle Version is 8.1.7.0.0 In the new server Oracle 8.1.7.4 is installed. What I am planning is to Shift the DB by copying the data files from old to new server. Renaming them in mount stage if required. For the Oracle version change (upgrade) will there be any problem? So that export/import will be the only option. Thanks for your valuable input. Regards ___ Download the hottest happening ringtones here! OR SMS: Top tone to 7333 Click here now: http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan 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: zhu chao 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: Different Platform
So which compiler will you standarize on? GCC? On Solaris I believe the Sun C Compiler is supported but not gcc, though you can make it work. -Original Message- Sent: Sunday, July 20, 2003 12:50 PM To: Multiple recipients of list ORACLE-L Hi All Our production environment is on Sun OS 5.8 sparc. DB is Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production PL/SQL Release 8.1.7.0.0 - Production CORE 8.1.7.0.0 Production TNS for Solaris: Version 8.1.7.0.0 - Production NLSRTL Version 3.4.1.0.0 - Production The application has a lot of Pro*C programs. -- We are planning to have the development/test DB on Linux 2.4 on Intel platform. We will be doing modifications/upgrades to the application and DB and will be applying the changes to production. Will there be ANY kind of compatibility problem (relating to OCI, or plsql procs etc) ? Thanks in Advance Regards ___ Download the hottest happening ringtones here! OR SMS: Top tone to 7333 Click here now: http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan 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: Richard Ji 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).