Re: DISK IO?

2001-10-04 Thread Rocky Welch
on (like subscribing). __ Do You Yahoo!? NEW from Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch IN

Re: User Processes Taking 200 Megs of RAM Upon Connecting

2001-09-13 Thread Rocky Welch
or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief informa

Re: awk, sed, windoze, sql*loader, other fun stuff

2001-08-29 Thread Rocky Welch
hoo! Messenger http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Deep Doo-Doo

2001-08-13 Thread Rocky Welch
rom). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Send instant messages & get email alerts with Yahoo! Messenger. http://im.

Re:OT -- training

2001-08-13 Thread Rocky Welch
CTED] (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). __ Do Y

RE: Off Topic - Anybody know how to copy a DVD?

2001-07-31 Thread Rocky Welch
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). __ Do You Yahoo!? Make

RE: (Fwd) Oracle8i Database Administration Boot camp

2001-07-31 Thread Rocky Welch
t, 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 (lik

Re: Looking for a tool

2001-07-25 Thread Rocky Welch
ed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FA

Re: How to search all tables for a particular field?

2001-07-19 Thread Rocky Welch
information (like subscribing). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch INET: [EMAIL PROTECTED] Fa

Oracle Applications 11i Help Files

2001-07-19 Thread Rocky Welch
://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: OEM help ???

2001-07-18 Thread Rocky Welch
__ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: Interesting query

2001-06-27 Thread Rocky Welch
l addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Maili

RE: Heads Up: Virus coming from list - Venkata Apparao

2001-06-27 Thread Rocky Welch
f was Deleted for the following reasons: > > Virus W32.Badtrans.13312@mm was found. > > __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.co

Re: Virus?

2001-06-27 Thread Rocky Welch
ining: 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). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.

Re: Query help !!! - Rewrite

2001-06-22 Thread Rocky Welch
How about: select f.customer_id from f, a, .b where f.customer_id = a.customer_id and f.customer_id = b.customer_id and a.customer_id = b.customer_id and f.status = 'F' and a.status = 'A' and b.status = 'B'; Much cleaner than t

Re: Query help !!!

2001-06-22 Thread Rocky Welch
m 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 in

Re: duel error

2001-06-19 Thread Rocky Welch
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). __ Do You Yahoo!? Spot the hottest trends

Digestive

2001-06-12 Thread Rocky Welch
SET ORACLE-L DIGESTIVE __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch INET

Re: Sun Solaris 8 - Listener failed to start a dedicated server proce

2001-05-22 Thread Rocky Welch
elete all files with a '.dat' extension. > d. Restart the Oracle database. > > 5. Use the Multi-Threaded Server (MTS) option. > -- > Jacques R. Kilchoer > (949) 754-8816 > Quest Software, Inc. > 8001 Irvine Center Drive > Irvine, California 92618 > U.S.A. > http://www.quest.com > ___

Re: OT: RE: job offer from SAUDI ARABIA

2001-05-18 Thread Rocky Welch
Thanks for this response. I rest my case. -Rocky --- "Mohan, Ross" <[EMAIL PROTECTED]> wrote: > || -Original Message----- > || From: Rocky Welch [mailto:[EMAIL PROTECTED]] > || Sent: Friday, May 18, 2001 10:57 AM > || To: Multiple recipients of list ORACLE

Re:adding columns to system tables

2001-05-18 Thread Rocky Welch
. ______ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch INET: [EMAIL PROTECTED] Fat City Network Services--

Re: Event ID 1008 in NT - Oracle 8.0.5

2001-05-18 Thread Rocky Welch
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). ______ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.c

RE: OT: RE: job offer from SAUDI ARABIA

2001-05-18 Thread Rocky Welch
people of this nation this weekend and keep your head down! AMERICA THE BEAUTIFUL! --- "Mohan, Ross" <[EMAIL PROTECTED]> wrote: > Not sorry if I touched a nerve, Rocky. > > That's what it's all about. It's democracy, > suck it up, or spit it out. &g

Re: OT: RE: job offer from SAUDI ARABIA

2001-05-17 Thread Rocky Welch
be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://w

Re: ....A drop schema script ??

2001-05-17 Thread Rocky Welch
- > UNFO;Pensacola;Florida;32534;U.S.A. > fn:Luis Octavio de Urioste > end:vcard > __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://ww

Re: DB Link Between Prod and Test?

2001-05-15 Thread Rocky Welch
iling list you want to be removed from). You may > also send the HELP command for other information (like subscribing). = Rocky Welch Senior Consultant - Internet Services Group Arthur Andersen __ Do You Yahoo!? Yahoo! Auctions - buy the things y

Re: OT: a bit of a brag...

2001-05-14 Thread Rocky Welch
lude 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). = Rocky Welch Senior Consultant - Internet Services Group Arthur Andersen

RE: Cool way to crash an Oracle database, any time, any place

2001-05-09 Thread Rocky Welch
mand for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Vikas Kawatra > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- P

Re: Off Topic: Unix shell problem

2001-04-26 Thread Rocky Welch
et 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 >

RE: OT: Reading the Oracle Tea Leaves

2001-04-26 Thread Rocky Welch
ce J > 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

Re: Off Topic: Unix shell script problem - Urgent advise needed

2001-04-26 Thread Rocky Welch
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 o

RE: Standard vs Enterprise

2001-04-20 Thread Rocky Welch
tall 817 Enterprise Edition. > -- install 817 Standard Editon > -- start the database and run catalog.sql and > catproc.sql > > > --- Rocky Welch <[EMAIL PROTECTED]> wrote: > > Are you sure? I read that the data dictionaries are > > not compatible. I know > > to

RE: Standard vs Enterprise

2001-04-20 Thread Rocky Welch
information (like subscribing). ______ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch INET: [EMAIL PROTECTED]

Re: How to break into DBA/Systems work without going broke doing it?

2001-03-29 Thread Rocky Welch
age 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). = Rocky Welch Senior Consultant - Internet Services Group Arthur Andersen

Opinions on this book...

2001-03-28 Thread Rocky Welch
h Yahoo! Mail. > > http://personal.mail.yahoo.com/?.refer=text > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Rocky Welch > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051

Trying to find a book...

2001-03-27 Thread Rocky Welch
lease see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

Re: What is best practice - differenet schema/different dbs

2001-03-27 Thread Rocky Welch
___ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch INET: [EMAIL P

Re: import/export

2001-03-21 Thread Rocky Welch
subscribing). __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch INET: [EMAIL PROTECTED] Fat City

RE: DBA Job at a Chocolate Factory

2001-03-21 Thread Rocky Welch
-- > 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 > als

Re: DBA Job at a Chocolate Factory

2001-03-21 Thread Rocky Welch
. You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

Re: ORA-24371

2001-03-14 Thread Rocky Welch
gt; > -Rocky > > __ > Do You Yahoo!? > Yahoo! Auctions - Buy the things you want at great prices. > http://auctions.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Roc

ORA-24371

2001-03-13 Thread Rocky Welch
Rocky __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

Off Topic?

2001-03-12 Thread Rocky Welch
: http://www.orafaq.com -- Author: Rocky Welch 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

Re: Max Extents Error

2001-03-08 Thread Rocky Welch
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 informa

Re: Max Extents Error

2001-03-08 Thread Rocky Welch
with Oracle 816. It is not > a prod environment instead a dev environment. > > Thanks > Sanjay > __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ:

Oracle Data Guard

2001-03-06 Thread Rocky Welch
FAQ: http://www.orafaq.com -- Author: Rocky Welch INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

Re: bitmap index problem

2001-03-06 Thread Rocky Welch
on (like subscribing). __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch INET: [EMAIL PROTECT

RE: Newbie question on Packages

2001-03-01 Thread Rocky Welch
> > 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

Re: Newbie question on Packages

2001-03-01 Thread Rocky Welch
--- > 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

Re: ora 27146 error ?

2001-03-01 Thread Rocky Welch
lude 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). = Rocky Welch Senior Consultant - Internet Services Group Arthur Andersen _

RE: Oracle Author in People Magazine

2001-03-01 Thread Rocky Welch
ifornia-- Public Internet access / Mailing Lists > > > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGu

Re: EXPORT PROBLEM

2001-02-28 Thread Rocky Welch
I hate to say it but consult the metalink. That's how I found out about it on 8.1.6. --- mala singh <[EMAIL PROTECTED]> wrote: > I am using 8.1.7.I think this is bug.What isur view > -Mala > > >From: Rocky Welch <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PR

Re: eek!

2001-02-28 Thread Rocky Welch
You may > also send the HELP command for other information (like subscribing). = Rocky Welch Senior Consultant - Internet Services Group Arthur Andersen __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo

Re: EXPORT PROBLEM

2001-02-28 Thread Rocky Welch
-- > 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 b

RE: RE: MetaSlop - Yet More Bleating and Moaning

2001-02-27 Thread Rocky Welch
work 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 'ListGu

Fwd: RE: Callout...SOLVED!

2001-02-26 Thread Rocky Welch
--- "Mohan, Ross" <[EMAIL PROTECTED]> wrote: > From: "Mohan, Ross" <[EMAIL PROTECTED]> > To: Rocky Welch <[EMAIL PROTECTED]> > Subject: RE: Callout...NOT SOLVED! > Date: Mon, 26 Feb 2001 12:48:11 -0500 > > BINGO. > > congrats on

RE: Callout...NOT SOLVED!

2001-02-23 Thread Rocky Welch
d > *** Error code 1 > make: Fatal error: Command failed for target `extproc.o' > ptcprodb> > > ______ > Do You Yahoo!? > Yahoo! Auctions - Buy the things you want at great prices! > http://auctions.yahoo.com/ > --

Callout...

2001-02-23 Thread Rocky Welch
y the things you want at great prices! http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public I

RE: System Tablespace

2001-02-20 Thread Rocky Welch
Be sure you use the compress=y variable if you want to consolidate the system tablespace extents. -Rocky   "Armstead, Michael A" <[EMAIL PROTECTED]> wrote: I also believe that you need to rebuild the database to defrag SYSTEM.Michael Armstead Database Administrator, OCP-CertifiedCorporate & Finan

Re: automatic startup and shutdown of LISTENER

2001-02-12 Thread Rocky Welch
Hi Van, Looks like you have a space between the path and lsnrctl. That might be the problem. HTH, -Rocky   "Van M. Etheridge" <[EMAIL PROTECTED]> wrote: I would like to be able tostartup and shutdown the listener when my SA shutsdown and brings the Unix box back up. What happens when my SA brings

Re: !!**** Urgent HELP (Table Deleted In Production )

2001-02-09 Thread Rocky Welch
Hi Saroj, If the table data isn't updated too often you can go back to an older export and import the table. If not, are you in archive log mode? Check your alert.log file for errors on the system datafile and let us know the status of your database to provide an accurate answer. -Rocky   "Dash, S

OWS Question...

2001-02-08 Thread Rocky Welch
Good Morning (in Florida anyway) Gang, I have a question about Web Server. After bringing the database OWS is connected to for a cold backup, is there a way to automatically restore the connection between the 2? We are running 8.1.6 on Solaris 8 and the OWS is running on NT SP6. We automatically br

Re: Strange command coming up when running sqlplus from Unix server...

2001-02-08 Thread Rocky Welch
Hi Natasha, Looks like an install problem. Check your /etc/system directory.   Natasha Batson <[EMAIL PROTECTED]> wrote: A customer of mine, whenever he logs into sqlplus on his Unix server he getsthe following:"oracle817> sqlplusinst emulated pid=28337 va=0x14005b9b8 pc=0x1200fda40inst=0x3be6000

RE: Pondering Question of the Day-RESPECT

2001-02-05 Thread Rocky Welch
Anyone heard from Lisa today or is she out job hunting? ;o)   Kimberly Smith <[EMAIL PROTECTED]> wrote: Sounds like you more like the backup DBA then just a developer.Congrs, I believe you wear two hats. Now go ask for a raise.-Original Message-Sent: Friday, February 02, 2001 10:40 AMTo:

RE: Pondering Question of the Day-RESPECT

2001-02-05 Thread Rocky Welch
Try this: "It sure would be a shame if all that work you did today were to somehow disappear. It would certainly be nice if somebody brought me a ." This works pretty well. -Rocky   Rachel Carmichael <[EMAIL PROTECTED]> wrote: hm, I like that. I've been working on training people here on the prop

RE: Who wants to build a tablespace...

2001-02-05 Thread Rocky Welch
A little more detail: I'm setting up a new application database for a customer who has hired a full-time dba. This system is on a Sun 4500 cluster with 2 D1000 disk arrays. This database will be no bigger than 50 gig with no more than 50 concurrent users. The full-time DBA inisists on 1 3gig dataf

Who wants to build a tablespace...

2001-02-02 Thread Rocky Welch
The question is...One BIG datafile (3 gig) or multiple smaller datafiles. You still have audience or phone a friend...your final answer? -RockyDo You Yahoo!? - Get personalized email addresses from Yahoo! Mail Personal Address - only $35 a year!

RE: OT NT2K vs Unix.

2001-02-01 Thread Rocky Welch
Air Bag? Windows Crash? The next generation of PC I can see it now. LOL This is a debate that will continue for years but it is entertaining. Thanks to all for the interesting reading. <= (True.Not sarcastic or mean.)   Kevin Kostyszyn <[EMAIL PROTECTED]> wrote: Good points and don't worry abou

RE: OT NT2K vs Unix.

2001-02-01 Thread Rocky Welch
-- MS, a software company, gave too much MoJo to developers. Imagine that. Same reason most of their software swamps the market. People can USE it. Shocking Development!  -----Original Message-From: Rocky Welch [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 01, 20001 3:28 PMTo: Multipl

RE: Primary Keys

2001-02-01 Thread Rocky Welch
WOW! Overhead city! If this is being done on such large tables I would strongly suggest a simple application modification to include a better way to query. It looks to me like a primary key is in order.   Brian Wisniewski <[EMAIL PROTECTED]> wrote: The will be querying off of customer id, check n

RE: OT NT2K vs Unix.

2001-02-01 Thread Rocky Welch
From the URL: http://www.microsoft.com/windows2000/guide/professional/solutions/overview/reliable/default.asp PCs Stay Up and Running Memory conflicts and missing or altered system files caused many of the system crashes prior to Windows 2000. To put an end to these problems, we changed Windows 20

Re: OT NT2K vs Unix.

2001-02-01 Thread Rocky Welch
The same prediction was made at least 5 years ago. At the rate Microsoft is going, Windows will be a direct form of Unix. It becomes more like it with every release. -Rocky   "Mohan, Ross" <[EMAIL PROTECTED]> wrote: Yea, but.. Win2K Datacenter will just decimate Unix. I predict that, in 5