Please look at this imp command
imp tpocs/[EMAIL PROTECTED] file=c:\Latest_Reference_Files\pharm_jul_2003.dmp log= c:\Latest_Reference_Files\pharm_jul_2003.log fromuser=tpocs touser=tpocs tables=arc_ndc commit=y ignore=y buffer=8388608 Scenario: I ran this command (as instructed by the tier III tech), got a couple of warnings but it did import 28K plus rows into arc_ndc. Before I ran the command at the command NT command level, I truncated arc_ndc via SQL*Plus. After the command completed I rebooted the server, there was no direction to do this, I just did it for good measure figuring I would get a clean oracle instance going. When the server finished the reboot, oracle wasn't up -- or I should say the database wasn't opened. I had to open the database as SYSDBA. Did the imp command close the database? I don't see any directive to do so, but being new maybe there is something I don't understand. Thanks for your help and patience. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI 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: Please look at this imp command
Hi Stephen, No imp wouldn't close or otherwise impact Oracle instance. I'd look at init.ora . Someone could make changes there, effective at reboot time Vadim -Original Message- [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 11:04 AM To: Multiple recipients of list ORACLE-L imp tpocs/[EMAIL PROTECTED] file=c:\Latest_Reference_Files\pharm_jul_2003.dmp log= c:\Latest_Reference_Files\pharm_jul_2003.log fromuser=tpocs touser=tpocs tables=arc_ndc commit=y ignore=y buffer=8388608 Scenario: I ran this command (as instructed by the tier III tech), got a couple of warnings but it did import 28K plus rows into arc_ndc. Before I ran the command at the command NT command level, I truncated arc_ndc via SQL*Plus. After the command completed I rebooted the server, there was no direction to do this, I just did it for good measure figuring I would get a clean oracle instance going. When the server finished the reboot, oracle wasn't up -- or I should say the database wasn't opened. I had to open the database as SYSDBA. Did the imp command close the database? I don't see any directive to do so, but being new maybe there is something I don't understand. Thanks for your help and patience. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI 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: Gorbounov,Vadim 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: Please look at this imp command
Two things to check immediately: (1) Is the Oracle service defined as started automatically in the services? (2) If yes, is there any error reported in alert log of the database? Import does not shut the database down. HTH Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 11:04 AM imp tpocs/[EMAIL PROTECTED] file=c:\Latest_Reference_Files\pharm_jul_2003.dmp log= c:\Latest_Reference_Files\pharm_jul_2003.log fromuser=tpocs touser=tpocs tables=arc_ndc commit=y ignore=y buffer=8388608 Scenario: I ran this command (as instructed by the tier III tech), got a couple of warnings but it did import 28K plus rows into arc_ndc. Before I ran the command at the command NT command level, I truncated arc_ndc via SQL*Plus. After the command completed I rebooted the server, there was no direction to do this, I just did it for good measure figuring I would get a clean oracle instance going. When the server finished the reboot, oracle wasn't up -- or I should say the database wasn't opened. I had to open the database as SYSDBA. Did the imp command close the database? I don't see any directive to do so, but being new maybe there is something I don't understand. Thanks for your help and patience. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI 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: Arup Nanda 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: Please look at this imp command
Stephen, From your email, here are the steps as I understand them: 1) run imp command 2) reboot the server (NT/Win2k?) 3) check database and find it is not open The reboot closed the database (and probably not gracefully). When the server restarted, the service may have started, but the database was not opened. I know there are registry settings to control this, but I don't know them off the top of my head. I am sure someone on the list can provide them. The bottom line...imp did not close the database, the server reboot did. Daniel Fink Wolfe Stephen S GS-11 6 MDSS/SGSI wrote: imp tpocs/[EMAIL PROTECTED] file=c:\Latest_Reference_Files\pharm_jul_2003.dmp log= c:\Latest_Reference_Files\pharm_jul_2003.log fromuser=tpocs touser=tpocs tables=arc_ndc commit=y ignore=y buffer=8388608 Scenario: I ran this command (as instructed by the tier III tech), got a couple of warnings but it did import 28K plus rows into arc_ndc. Before I ran the command at the command NT command level, I truncated arc_ndc via SQL*Plus. After the command completed I rebooted the server, there was no direction to do this, I just did it for good measure figuring I would get a clean oracle instance going. When the server finished the reboot, oracle wasn't up -- or I should say the database wasn't opened. I had to open the database as SYSDBA. Did the imp command close the database? I don't see any directive to do so, but being new maybe there is something I don't understand. Thanks for your help and patience. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI 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).begin:vcard n:Fink;Daniel tel;cell:303.808.3282 tel;work:303.272.3225 x-mozilla-html:TRUE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] title:DB Services Lead x-mozilla-cpt:;-4832 fn:Daniel Fink end:vcard
RE: Please look at this imp command
I'm starting to gather that -- that the reboot did it. Entertainingly enough I had enough presence of mind to use EM As SYSDBA and open the database using the InitTPOCS.ora. The users have been using the application for the last four hours without any issues, so, what is the graceful way of shutting down the database, via, EM and do a close? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Daniel Fink [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 1:09 PM To: Multiple recipients of list ORACLE-L Subject: Re: Please look at this imp command Stephen, From your email, here are the steps as I understand them: 1) run imp command 2) reboot the server (NT/Win2k?) 3) check database and find it is not open The reboot closed the database (and probably not gracefully). When the server restarted, the service may have started, but the database was not opened. I know there are registry settings to control this, but I don't know them off the top of my head. I am sure someone on the list can provide them. The bottom line...imp did not close the database, the server reboot did. Daniel Fink Wolfe Stephen S GS-11 6 MDSS/SGSI wrote: imp tpocs/[EMAIL PROTECTED] file=c:\Latest_Reference_Files\pharm_jul_2003.dmp log= c:\Latest_Reference_Files\pharm_jul_2003.log fromuser=tpocs touser=tpocs tables=arc_ndc commit=y ignore=y buffer=8388608 Scenario: I ran this command (as instructed by the tier III tech), got a couple of warnings but it did import 28K plus rows into arc_ndc. Before I ran the command at the command NT command level, I truncated arc_ndc via SQL*Plus. After the command completed I rebooted the server, there was no direction to do this, I just did it for good measure figuring I would get a clean oracle instance going. When the server finished the reboot, oracle wasn't up -- or I should say the database wasn't opened. I had to open the database as SYSDBA. Did the imp command close the database? I don't see any directive to do so, but being new maybe there is something I don't understand. Thanks for your help and patience. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI 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: Wolfe Stephen S GS-11 6 MDSS/SGSI 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: Please look at this imp command
INLINE snip Two things to check immediately: (1) Is the Oracle service defined as started automatically in the services? Yes (2) If yes, is there any error reported in alert log of the database? Compared line-by-line the last three starts and they seem identical, nothing unusual in the last start. Anyway here is today's entries: Tue Jul 29 03:44:39 2003 Thread 1 advanced to log sequence 73 Current log# 1 seq# 73 mem# 0: D:\ORACLE\ORADATA\TPOCS\REDO01.LOG Tue Jul 29 03:45:00 2003 Thread 1 advanced to log sequence 74 Current log# 2 seq# 74 mem# 0: D:\ORACLE\ORADATA\TPOCS\REDO02.LOG Tue Jul 29 03:45:31 2003 Thread 1 advanced to log sequence 75 Current log# 3 seq# 75 mem# 0: D:\ORACLE\ORADATA\TPOCS\REDO03.LOG Dump file D:\oracle\admin\tpocs\bdump\tpocsALRT.LOG Tue Jul 29 05:31:23 2003 ORACLE V9.0.1.1.1 - Production vsnsta=0 vsnsql=10 vsnxtr=3 Windows 2000 Version 5.0 Service Pack 3, CPU type 586 Starting up ORACLE RDBMS Version: 9.0.1.1.1. System parameters with non-default values: processes= 150 timed_statistics = TRUE shared_pool_size = 50331648 java_pool_size = 33554432 control_files= D:\oracle\oradata\tpocs\control01.ctl, D:\oracle\oradata\tpocs\control02.ctl, D:\oracle\oradata\tpocs\control03.ctl db_block_size= 4096 db_cache_size= 33554432 compatible = 9.0.0 fast_start_mttr_target = 300 undo_management = AUTO undo_tablespace = UNDOTBS remote_login_passwordfile= EXCLUSIVE db_domain= instance_name= tpocs background_dump_dest = D:\oracle\admin\tpocs\bdump user_dump_dest = D:\oracle\admin\tpocs\udump core_dump_dest = D:\oracle\admin\tpocs\cdump sort_area_size = 524288 db_name = tpocs open_cursors = 300 PMON started with pid=2 DBW0 started with pid=3 LGWR started with pid=4 CKPT started with pid=5 SMON started with pid=6 RECO started with pid=7 Tue Jul 29 05:31:26 2003 /* OracleOEM */ ALTER DATABASE MOUNT Tue Jul 29 05:31:31 2003 Successful mount of redo thread 1, with mount id 1877649006. Tue Jul 29 05:31:31 2003 Database mounted in Exclusive Mode. Completed: /* OracleOEM */ ALTER DATABASE MOUNT Tue Jul 29 05:31:31 2003 /* OracleOEM */ ALTER DATABASE OPEN Tue Jul 29 05:31:32 2003 Beginning crash recovery of 1 threads Tue Jul 29 05:31:33 2003 Started first pass scan Tue Jul 29 05:31:33 2003 Completed first pass scan Tue Jul 29 05:31:38 2003 Started recovery at Thread 1: logseq 74, block 202409, scn 0.0 Recovery of Online Redo Log: Thread 1 Group 2 Seq 74 Reading mem 0 Mem# 0 errs 0: D:\ORACLE\ORADATA\TPOCS\REDO02.LOG Recovery of Online Redo Log: Thread 1 Group 3 Seq 75 Reading mem 0 Mem# 0 errs 0: D:\ORACLE\ORADATA\TPOCS\REDO03.LOG Tue Jul 29 05:31:39 2003 Ended recovery at Thread 1: logseq 75, block 18467, scn 0.2938502 3305 data blocks read, 3305 data blocks written, 20858 redo blocks read Crash recovery completed successfully Tue Jul 29 05:31:40 2003 Thread 1 advanced to log sequence 76 Thread 1 opened at log sequence 76 Current log# 1 seq# 76 mem# 0: D:\ORACLE\ORADATA\TPOCS\REDO01.LOG Successful open of redo thread 1. Tue Jul 29 05:31:40 2003 SMON: enabling cache recovery Tue Jul 29 05:31:41 2003 Undo Segment 1 Onlined Undo Segment 2 Onlined Undo Segment 3 Onlined Undo Segment 4 Onlined Undo Segment 5 Onlined Undo Segment 6 Onlined Undo Segment 7 Onlined Undo Segment 8 Onlined Undo Segment 9 Onlined Undo Segment 10 Onlined Successfully onlined Undo Tablespace 1. Tue Jul 29 05:31:41 2003 SMON: enabling tx recovery Tue Jul 29 05:31:43 2003 replication_dependency_tracking turned off (no async multimaster replication found) Completed: /* OracleOEM */ ALTER DATABASE OPEN Import does not shut the database down. I didn't think so. I'm just wondering why when I rebooted the server the TPOCS instance did start, it is like It didn't grab the InitTpocs.ora ...perplexed (but understandable when you are in the constant learn mode. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI 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: Please look at this imp command
I'm embarrassed ... Shutdown immediate via SQL*Plus after verifying all users have disconnected. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Wolfe Stephen S GS-11 6 MDSS/SGSI Sent: Tuesday, July 29, 2003 1:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: Please look at this imp command I'm starting to gather that -- that the reboot did it. Entertainingly enough I had enough presence of mind to use EM As SYSDBA and open the database using the InitTPOCS.ora. The users have been using the application for the last four hours without any issues, so, what is the graceful way of shutting down the database, via, EM and do a close? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Daniel Fink [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 1:09 PM To: Multiple recipients of list ORACLE-L Subject: Re: Please look at this imp command Stephen, From your email, here are the steps as I understand them: 1) run imp command 2) reboot the server (NT/Win2k?) 3) check database and find it is not open The reboot closed the database (and probably not gracefully). When the server restarted, the service may have started, but the database was not opened. I know there are registry settings to control this, but I don't know them off the top of my head. I am sure someone on the list can provide them. The bottom line...imp did not close the database, the server reboot did. Daniel Fink Wolfe Stephen S GS-11 6 MDSS/SGSI wrote: imp tpocs/[EMAIL PROTECTED] file=c:\Latest_Reference_Files\pharm_jul_2003.dmp log= c:\Latest_Reference_Files\pharm_jul_2003.log fromuser=tpocs touser=tpocs tables=arc_ndc commit=y ignore=y buffer=8388608 Scenario: I ran this command (as instructed by the tier III tech), got a couple of warnings but it did import 28K plus rows into arc_ndc. Before I ran the command at the command NT command level, I truncated arc_ndc via SQL*Plus. After the command completed I rebooted the server, there was no direction to do this, I just did it for good measure figuring I would get a clean oracle instance going. When the server finished the reboot, oracle wasn't up -- or I should say the database wasn't opened. I had to open the database as SYSDBA. Did the imp command close the database? I don't see any directive to do so, but being new maybe there is something I don't understand. Thanks for your help and patience. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI 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: Wolfe Stephen S GS-11 6 MDSS/SGSI 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: Wolfe Stephen S GS-11 6 MDSS/SGSI 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: Please look at this imp command
don't be... this means you are doing something we strongly advocate on this list... reading the manuals and learning. --- Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] wrote: I'm embarrassed ... Shutdown immediate via SQL*Plus after verifying all users have disconnected. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Wolfe Stephen S GS-11 6 MDSS/SGSI Sent: Tuesday, July 29, 2003 1:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: Please look at this imp command I'm starting to gather that -- that the reboot did it. Entertainingly enough I had enough presence of mind to use EM As SYSDBA and open the database using the InitTPOCS.ora. The users have been using the application for the last four hours without any issues, so, what is the graceful way of shutting down the database, via, EM and do a close? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Daniel Fink [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 1:09 PM To: Multiple recipients of list ORACLE-L Subject: Re: Please look at this imp command Stephen, From your email, here are the steps as I understand them: 1) run imp command 2) reboot the server (NT/Win2k?) 3) check database and find it is not open The reboot closed the database (and probably not gracefully). When the server restarted, the service may have started, but the database was not opened. I know there are registry settings to control this, but I don't know them off the top of my head. I am sure someone on the list can provide them. The bottom line...imp did not close the database, the server reboot did. Daniel Fink Wolfe Stephen S GS-11 6 MDSS/SGSI wrote: imp tpocs/[EMAIL PROTECTED] file=c:\Latest_Reference_Files\pharm_jul_2003.dmp log= c:\Latest_Reference_Files\pharm_jul_2003.log fromuser=tpocs touser=tpocs tables=arc_ndc commit=y ignore=y buffer=8388608 Scenario: I ran this command (as instructed by the tier III tech), got a couple of warnings but it did import 28K plus rows into arc_ndc. Before I ran the command at the command NT command level, I truncated arc_ndc via SQL*Plus. After the command completed I rebooted the server, there was no direction to do this, I just did it for good measure figuring I would get a clean oracle instance going. When the server finished the reboot, oracle wasn't up -- or I should say the database wasn't opened. I had to open the database as SYSDBA. Did the imp command close the database? I don't see any directive to do so, but being new maybe there is something I don't understand. Thanks for your help and patience. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI 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: Wolfe Stephen S GS-11 6 MDSS/SGSI 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: Wolfe Stephen S GS-11 6 MDSS/SGSI 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