RE: Clone db 9.2 on AIX 5L
/u02/oradata/spap/indexes03.dbf' 27 CHARACTER SET WE8ISO8859P1 28 ; CREATE CONTROLFILE REUSE DATABASE SPAP RESETLOGS NOARCHIVELOG * ERROR at line 1: ORA-03114: not connected to ORACLE SQL -- RECOVER DATABASE SQL -- ALTER DATABASE OPEN; SQL -- ALTER TABLESPACE TEMP ADD TEMPFILE '/iu33/u02/oradata/spap/temp01.dbf' SIZE 3119M REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE ; SQL The confusing thing is that I have instances already running on the machine. So I know the install is ok. I can start/shutdown the existing instances no problem. But when I try to clone and startup --- I get the results from above. -Original Message- Sent: Monday, October 27, 2003 5:24 PM To: [EMAIL PROTECTED] When are you getting the error? During startup? Adam John Blake [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/27/2003 03:04 PM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc Subject RE: Clone db 9.2 on AIX 5L Sorry, AIX 5L to AIX 5L cold backup copies create backup controlfile to trace -- edited for the new file locations keeping the SID the same created init.ora from spfile startup nomount pfile=init.ora getting ora-3113 I have a TAR opened and figured I would check out here as well. -Original Message- [EMAIL PROTECTED] Sent: Monday, October 27, 2003 4:44 PM To: Multiple recipients of list ORACLE-L How about some more details? Are you cloning to a similar platform? Are you using a cold backup with controlfile recreation? RMAN backup or restore? RMAN duplicate? ... Adam John Blake [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/27/2003 02:24 PM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc Subject Clone db 9.2 on AIX 5L Just checking to see if anyone has been able to clone a 9.2 DB from one machine to another. I have never had a problem doing this prior to 9.2, and am just wondering if I have overlooked something peculiar to 9i. Thanks in adavance John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Blake 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: John Blake 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: John Blake 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: Durinda.Jones 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
RE: Oracle Roles
In the good old days when you had books (which I still have around, even tho they're getting outdated) this info was in the Administrator's Guide, Chapter 12. Durinda -Original Message- Sent: Wednesday, January 30, 2002 3:15 PM To: Multiple recipients of list ORACLE-L I hate Oracle documentation on CD! Can anyone tell me where to find the definitions for the Oracle Roles? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: Durinda.Jones 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: Dangerous AIX Bug!
I agree. What a find! Durinda -Original Message- Sent: Thursday, July 26, 2001 5:16 PM To: Multiple recipients of list ORACLE-L OH MY GOD. that is s useful! A blessing on your family, your family's family, and your family's family's family. Oh hell, throw in a beer for yourself. thanks, Ross -Original Message- Sent: Thursday, July 26, 2001 4:52 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Ross, Check this link. You may find it useful. http://home.earthlink.net/~bhami/rosetta.html Regards, Denny Mohan, Ross wrote: :) My biggest concern is porting db's from other unix flavors...i wish there were a cross platfrom shell porting guide. Sure, ls is ls, but every mfgr changes the order/formatting of the flags and/or output. I am compiling responses and will post a summary. I have some good stuff so far hth Ross p.s. I wish i could get some (mostly) grass fed beef! ;-) _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Durinda.Jones 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: Dangerous AIX Bug!
Ross, We're running 8162 OPS on AIX 4.3. Chat away... Durinda -Original Message- Sent: Wednesday, July 25, 2001 9:36 AM To: Multiple recipients of list ORACLE-L ...just kidding, thought that would get your attention. But seriously: does anyone out there use Oracle 8i on AIX 4.3 or 5L? I'd like to chat w/you if so. Thanks! - Ross p.s. hmmm...maybe there *is* a bug in AIX and that's one of the things I'll learn:-) -Original Message- Sent: Tuesday, July 10, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Ron, I've attached one that I also got from the list some time ago, you may need to use something like bablefish to translate the comments :) HTH Mark -Original Message- L. Sent: Tuesday, July 10, 2001 02:32 To: Multiple recipients of list ORACLE-L Last week I was bit by a corrupt block on an index. I run Analyze every week which I found has been blowing up for some time due to the block corruption. Since Analyze does not create a log I did not know the Analyze was blowing up. Now I know that there are messages in the alert log that would have told me I had problems with the Analyze and the index. To make a long story short I need a good log scan script. Hopefully one that will work on Unix and NT. Mainly Unix. If anyone can help I would appreciate it. Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Durinda.Jones 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: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED
subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder 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: Durinda.Jones 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: TZ in AIX
Rahul, You can set the time so it won't recognize Daylight Savings Time, if that's what the problem is. The sysadmin needs to do the following: smitty choose System Environments choose Change / Show Date and Time choose Change Time Zone Using System Defined Values You'll get a pop-up window that asks the following: Use DAYLIGHT SAVINGS TIME?x x x x Move cursor to desired item and press Enter. x x x x # Does this time zone go on x x # DAYLIGHT SAVINGS TIME? x x # x x 1 yes x x 2 no Depending on what you choose, you'll get a list to set the timezone. This should take care of it. Durinda Jones Yellow Technologies -Original Message- Sent: Wednesday, April 04, 2001 6:06 AM To: Multiple recipients of list ORACLE-L List, our server has suddenly ahead 1 hour... it happened last year also something to do with the timezone... TZ variable.. is there a timezonewe could set which remains constant (does not go ahead 1 hour) thruout the year ? regards -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul 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: Durinda.Jones 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: Near-table/far-table join problem
Create a synonym for F1_V@FAR and reference the synonym in your query. Durinda -Original Message- Sent: Tuesday, March 06, 2001 6:46 AM To: Multiple recipients of list ORACLE-L We have a report running on database NEAR using table N1. This report does a join to a view in another database - FAR - using a database link to a view of a table F1_V. Fron SQLPLUS on NEAR I can select * from F1_V@FAR no problem. But when I do select * from N1 N, F1_V@FAR F where N.col = F.col; Here we are getting a 1041 error "hostdef extension does not exist". This is a generic connectivity problem. Does anyone know how to solve this problem?? ..tom -- 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: Durinda.Jones 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: No record in import help me please :..(
Set IGNORE=Y, SHOW=N in your import parameters. The table already exists, so you need to ignore errors, otherwise it won't import the rows. SHOW=Y will only list the contents of the export file, so it needs to be set to N (or not set it at all) so the rows will be imported. I would use care using the DESTROY=Y parameter. This could create a serious problem if you were to use it in a full import. Durinda -Original Message- Sent: Monday, March 05, 2001 8:45 AM To: Multiple recipients of list ORACLE-L Hi guys, 1. In my Oracle I have accounts : - teddy/bear (normal user can create) - sun/solaris (granted DBA role) 2. I run the catexp.sql using sys account (just one error occur IMP_FULL_DATABASE confilct) 3. TEDDY created a table EMP with 7 records 4. I am using Sun account to export teddy table: inside my params.dat : FILE=/export/home/dba/myemp.dmp TABLES=(teddy.emp) ROWS=Y GRANTS=Y COMPRESS=Y I export with this params.dat : exp sun/solaris parfile=/export/home/dba/myemp.dmp I've got messsges : . . exporting table EMP 7 rows exported 5. I check the file is exist and with -rw-rw-rw 1 dbadmin 3072 Mar (time) myemp.dmp 6. I chmod a+x myemp.dmp 7. teddy delete emp table : delete emp 7 rows deleted 8. when as sun I try to import : inside my imp_params.dat : FILE=/export/home/dba/myemp.dmp SHOW=Y IGNORE=N GRANTS=Y ROWS=Y DESTROY=Y COMMIT=Y I import imp sun/solaris parfile=imp_params.dat 9. the messeges that I got : ... ... .skipping table "EMP" ... ... ... ... Import terminated successfully without warnings. 10. When teddy select * from emp; 0 rows selected Can someone help me please... please ??? :( -- 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: Durinda.Jones 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: No record in import help me please :..(
Set IGNORE=Y, SHOW=N in your import parameters. The table already exists, so you need to ignore errors, otherwise it won't import the rows. SHOW=Y will only list the contents of the export file, so it needs to be set to N (or not set it at all) so the rows will be imported. Use the FROMUSER/TOUSER parameters if you are wanting to change the owner of the table. If you still want TEDDY to own the table, you don't need to use FROMUSER/TOUSER. The SUN user has DBA privilege, which will allow it to change to the TEDDY user and import the table. I would use care using the DESTROY=Y parameter. This could create a serious problem if you were to use it in a full import. This overwrites existing datafiles. I seldom use it in day-to-day operations. Durinda -Original Message- Sent: Monday, March 05, 2001 8:45 AM To: Multiple recipients of list ORACLE-L Hi guys, 1. In my Oracle I have accounts : - teddy/bear (normal user can create) - sun/solaris (granted DBA role) 2. I run the catexp.sql using sys account (just one error occur IMP_FULL_DATABASE confilct) 3. TEDDY created a table EMP with 7 records 4. I am using Sun account to export teddy table: inside my params.dat : FILE=/export/home/dba/myemp.dmp TABLES=(teddy.emp) ROWS=Y GRANTS=Y COMPRESS=Y I export with this params.dat : exp sun/solaris parfile=/export/home/dba/myemp.dmp I've got messsges : . . exporting table EMP 7 rows exported 5. I check the file is exist and with -rw-rw-rw 1 dbadmin 3072 Mar (time) myemp.dmp 6. I chmod a+x myemp.dmp 7. teddy delete emp table : delete emp 7 rows deleted 8. when as sun I try to import : inside my imp_params.dat : FILE=/export/home/dba/myemp.dmp SHOW=Y IGNORE=N GRANTS=Y ROWS=Y DESTROY=Y COMMIT=Y I import imp sun/solaris parfile=imp_params.dat 9. the messeges that I got : ... ... .skipping table "EMP" ... ... ... ... Import terminated successfully without warnings. 10. When teddy select * from emp; 0 rows selected Can someone help me please... please ??? :( -- 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: Durinda.Jones 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: Re:Anyone using CA products?
Ruth, It's probably because you work for a government agency. I used to work for the federal government, and have found that a lot of things have changed since I went to private industry. Support and dealings with some vendors (not to mention any names) have changed dramatically. That's still not enough to make me want to go back to that sweatshop. By the way, CA is less than helpful here, on the Oracle or the DB2 side of the house. Durinda Jones Yellow Technologies -Original Message- Sent: Monday, February 26, 2001 10:16 AM To: Multiple recipients of list ORACLE-L I am using Platinum DesktopDBA. I got an upgrade with no problem and the sales team even came over here to visit and make sure I was satisfied. Ruth B. Gramolini ORACLE DB2 DBA VT Dept. of Taxes ph# 802.828.5708 fax# 802.828..3754 [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Friday, February 23, 2001 5:05 PM Ron, Common on now, this is suppose to be at least a polite list. There was no call for the use of foul language. OH, sorry you don't work over here, CA is a four letter work here used only in EXTREME circumstances like when the fire dept accidentally sets off the fire suppression system in the computer room on a Friday late afternoon. Dick Goulet Reply Separator Author: "Smith; Ron L." [EMAIL PROTECTED] Date: 2/23/2001 1:00 PM I have been trying to get upgrades from Computer Associates for about two months. Does anyone use any of Computer Associates products? What has been your experience? Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: Ruth Gramolini 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: Durinda.Jones 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).