| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re[2]: Big Whoops
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFCA62.46580FA0
Content-Type: text/plain;
charset="iso-8859-1"
I think that the best way is to have a procedure which can be called from glogin.sql, owned by sys and grant execute to public - to get data from v$session and v$database. Also we can create script in SQLPATH directory which will call glogin.sql, so every time after entering connect user/password_at_alias one shoud run this script - like @c
Alex Hillman
-----Original Message-----
From: Jack van Zanen [mailto:nlzanen1_at_ey.nl]
Sent: Tuesday, May 30, 2000 3:15 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Re[2]: Big Whoops
Hi
I created a little script called "c" and placed it's location in the
registry
sqlpath which I call to change the connection
accept username prompt "Type username :";
accept password prompt "Type Password (wordt niet getoond) :" hide;
accept sid prompt "Type instance naam (SID) :";
connect &username/&password@&sid;
@c:\orawin95\plus80\Glogin.sql;
undefine username;
undefine password;
undefine sid;
rem CLEAR SCREEN;
I always use this i.s.o. connect
Jack
Ari D Kaplan <akaplan_at_interaccess.com>@fatcity.com on 05/30/2000 03:08:12 AM
Please respond to ORACLE-L_at_fatcity.com
Sent by: root_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:
Thanks Kirti for providing this in Oracle7.
One problem with this is if you are already connected and issue:
connect username/password_at_DB_LINK;
I don't know how to get around that... if anyone out there knows how to refresh the prompt when you issue "connect" that would be great.
Why are we doing this on a holiday? Well, I already had my corn on the cob, and the email is always on, so.....
Regards,
-Ari
www.arikaplan.com
On Mon, 29 May 2000, Deshpande, Kirti wrote:
> Here is one way to do this in Oracle 7 that I know.. It shows the machine
> name and sid name just before the SQL> prompt....
> However, the prompt won't change for remote connections made from local
the
> local connection.
>
> set termout off
> col myprompt noprint new_value myprompt_new
> SELECT 'SQL> ' myprompt from dual;
> SELECT substr(proc.program,
> instr(proc.program,'@')+1,
> instr(proc.program,' ') - instr(proc.program,'@')) ||
> '[' || param.value ||
> '] SQL> ' myprompt
> FROM v$process proc, v$parameter param
> WHERE param.name = 'db_name'
> AND proc.pid = 2;
> set sqlprompt '&&myprompt_new'
> /
> set termout on
>
> HTH..
> - Kirti
>
>
> > -----Original Message-----
> > From: Jared Still [SMTP:jkstill_at_bcbso.com]
> > Sent: Monday, May 29, 2000 6:24 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Re[2]: Big Whoops
> >
> >
> > Oops. I didn't scroll down and read the
> > entire message. Sorry about that.
> >
> > What I had in mind, but didn't say, ( the SEND
> > key is faster than the brain ) was in regards
> > to version 7 databases.
> >
> > I used to pull the machine name out of MTS
> > configuration info, but we don't use MTS here.
> >
> > Any idea how to do this in 7.x databases?
> >
> > Thanks
> >
> > Jared
> >
> > P.S. Why are we doing this on a holiday?
> >
> > On Mon, 29 May 2000, Ari D Kaplan wrote:
> >
> > > I believe the example shows how to embed the machine name.
> > >
> > > SELECT 'set sqlprompt '''|| d.name ||'@' ||
> > > substr(s.machine,1,decode (instr(s.machine,'.'), 0,
> > length(s.machine),
> > > instr(s.machine,'.') - 1)) ||
> > > '-SQL> '''
> > > FROM V$SESSION s, V$DATABASE D
> > > WHERE s.SID=1;
> > >
> > > The output will look like:
> > > set sqlprompt 'PHIS_at_survlpd-SQL> '
> > >
> > >
> > > In the above example, "survlpd" is the machine name.
> > >
> > > -Ari
> > > www.arikaplan.com
> > > On Mon, 29 May 2000, Jared Still wrote:
> > >
> > > >
> > > > In that case, maybe you could provide various methods
> > > > of embedding the machine name in the SQL prompt as well.
> > > >
> > > > Jared
> > > >
> > > > On Sat, 27 May 2000, Ari D Kaplan wrote:
> > > >
> > > > > I do the SQL prompt change as well... for the listers benefit I am
> > > > > providing part of my upcoming EOUG speech (how many of you really
> > are
> > > > > coming?) that explains how to do this...
> > > > >
> > > > > -Ari
> > > > > www.arikaplan.com
> > > > >
> > > > > When you first get your Oracle CD-ROM, install and create your
> > database,
> > > > > and go to SQL*Plus, you are greeted with the familiar "SQL>"
prompt.
> > What
> > > > > many Oracle professionals do not know is that this prompt can be
> > changed.
> > > > > It could be useful to have the prompt give the time, the username,
> > which
> > > > > machine you are on, or any other information particular to an
> > application.
> > > > > The prompt is most easily changed by modifying the global or local
> > login
> > > > > scripts. The global login script, which is the
> > > > > $ORACLE_HOME/sqlplus/admin/glogin.sql file, gets run when anyone
> > connects
> > > > > to the database. It is here that you can put in SQL to control
what
> > > > > happens when a user invokes SQL*Plus. Common commands are
formatting
> > of
> > > > > columns, setting PAGESIZE, putting in messages, changing optimizer
> > goals,
> > > > > or changing the prompt. For example:
> > > > > set heading off
> > > > > select 'Logged in as ' || username from user_users;
> > > > > set heading on
> > > > > will print "Logged in as SCOTT" when you connect as SCOTT.
> > > > > If there is a file in $ORACLE_PATH called "login.sql", it is
> > referred to
> > > > > as a local login script. This will override the global login
script.
> > If
> > > > > you use local or global login scripts, you can change the SQL
> > prompt.
> > > > > SELECT 'set sqlprompt '''|| d.name ||'@' ||
> > > > > substr(s.machine,1,decode (instr(s.machine,'.'), 0,
> > length(s.machine),
> > > > > instr(s.machine,'.') - 1)) ||
> > > > > '-SQL> '''
> > > > > FROM V$SESSION s, V$DATABASE D
> > > > > WHERE s.SID=1;
> > > > > The output will look like:
> > > > > set sqlprompt 'PHIS_at_survlpd-SQL> '
> > > > > This will use the "SET SQLPROMPT" command to be the instance name
> > and the
> > > > > server name. For this to work, you will need to spool the result
of
> > the
> > > > > SELECT clause to a file, and then run the file. Putting it all
> > together:
> > > > > set heading off
> > > > > set prompt off
> > > > > spool make_prompt.sql
> > > > > SELECT 'set sqlprompt '''|| d.name ||'@' ||
> > > > > substr(s.machine,1,decode (instr(s.machine,'.'), 0,
> > length(s.machine),
> > > > > instr(s.machine,'.') - 1)) ||
> > > > > '-SQL> '''
> > > > > FROM V$SESSION s, V$DATABASE D
> > > > > WHERE s.SID=1;
> > > > > spool off
> > > > > @make_prompt.sql
> > > > > set heading on
> > > > > set feedback on
> > > > > You will now have a nice prompt each time you connect. With
multiple
> > > > > windows open on your computer, this is a good way to keep track of
> > which
> > > > > database each window is connect to.
> > > > >
> > > > >
> > > > > On Sat, 27 May 2000, Jared Still wrote:
> > > > >
> > > > > >
> > > > > > > Since then I color-code my windows (light red on black for
> > production
> > > > > > > windows)...
> > > > > >
> > > > > > This seems to work for some people. A fellow DBA here at
> > > > > > Blue Cross does this.
> > > > > >
> > > > > > It never seemed to work for me. Embedding the database name
> > > > > > in the SQL prompt seems to work best, at least for me.
> > > > > >
> > > > > > Jared
> > > > > >
> > > > > > >
> > > > > > > Steve, Rachel - you are not alone...
> > > > > > >
> > > > > > >
> > > > > > > -Ari
> > > > > > >
> > > > > > > On Thu, 25 May 2000, Rachel Carmichael wrote:
> > > > > > >
> > > > > > > > me....
> > > > > > > >
> > > > > > > > logged into two terminals, one was production, one was test.
> > In both the
> > > > > > > > tablespaces had the same names. So I think I am going to
drop
> > the two
> > > > > > > > tablespaces in test, so I can recreate from production.
> > > > > > > >
> > > > > > > > I do alter tablespace <xxx> offline;
> > > > > > > > drop tablespace <xxx> including contents;
> > > > > > > >
> > > > > > > > and then scream as I realize I dropped a production
> > tablespace. I go into my
> > > > > > > > user's office and tell him he can kill me later, this is
what
> > I did, how
> > > > > > > > does he want me to proceed to fix it. fortunately the
> > production one was
> > > > > > > > static data, and could be recreated. we do so.
> > > > > > > >
> > > > > > > > he then tells me I have used up all my screw-ups for the
next
> > 5 years.
> > > > > > > >
> > > > > > > > everyone does stupid stuff. the trick is to admit it and
know
> > how to recover
> > > > > > > > from it
> > > > > > > >
> > > > > > > > Rachel
> > > > > > > >
> > > > > > > >
> > > > > > > > >From: "Steve Boyd" <pimaco_oracle_at_hotmail.com>
> > > > > > > > >Reply-To: ORACLE-L_at_fatcity.com
> > > > > > > > >To: Multiple recipients of list ORACLE-L
> > <ORACLE-L_at_fatcity.com>
> > > > > > > > >Subject: Re: Re[2]: Big Whoops
> > > > > > > > >Date: Thu, 25 May 2000 07:38:38 -0800
> > > > > > > > >
> > > > > > > > >I'd like to post a question for everyone on the list.
> > > > > > > > >
> > > > > > > > >How many of you have ever dropped a table, or done
something
> > like that in
> > > > > > > > >the wrong database(thinking you were connected to say the
> > test DB), and
> > > > > > > > >hosed production?
> > > > > > > > >
> > > > > > > > >Steve Boyd
> > > > > > > > >
> > > > > > > > >>From: dgoulet_at_vicr.com
> > > > > > > > >>Reply-To: ORACLE-L_at_fatcity.com
> > > > > > > > >>To: Multiple recipients of list ORACLE-L
> > <ORACLE-L_at_fatcity.com>
> > > > > > > > >>Subject: Re[2]: Big Whoops
> > > > > > > > >>Date: Thu, 25 May 2000 06:40:46 -0800
> > > > > > > > >>
> > > > > > > > >>A couple of years ago I was trying to create a new
instance
> > on one of our
> > > > > > > > >>Unix
> > > > > > > > >>boxes to support an additional manufacturing line. Since
> > the first
> > > > > > > > >>instance was
> > > > > > > > >>well tuned, I copied the init.ora file to a new name & did
> > the little
> > > > > > > > >>editing
> > > > > > > > >>that I believed necessary, like a new db_name. What I
> > forgot was the
> > > > > > > > >>control_file line. You can guess what happen next, yes
the
> > control files
> > > > > > > > >>got
> > > > > > > > >>trashed and the original instance terminated with errors.
> > We had to
> > > > > > > > >>recover
> > > > > > > > >>that one from tape since I hadn't backed up the control
> > files to trace for
> > > > > > > > >>some
> > > > > > > > >>time, but I do now at every shutdown. We live & learn
from
> > our mistakes,
> > > > > > > > >>hopefully NOT on a production server.
> > > > > > > > >>
> > > > > > > > >>
> > > > > > > > >>BTW: My advice to any new DBA out there is that when an
> > emergency hits
> > > > > > > > >>you,
> > > > > > > > >>or
> > > > > > > > >>an AW SH%$. First step in the process is to step back,
take
> > a deep breath
> > > > > > > > >>&
> > > > > > > > >>calm down. Adrenaline and instant reaction are your worst
> > enemies.
> > > > > > > > >>
> > > > > > > > >>Dick Goulet
> > > > > > > > >>Senior Oracle DBA
> > > > > > > > >>Vicor Corporation
> > > > > > > > >>
> > > > > > > > >>____________________Reply Separator____________________
> > > > > > > > >>Author: "Rachel Carmichael" <carmichr_at_hotmail.com>
> > > > > > > > >>Date: 5/24/00 6:16 PM
> > > > > > > > >>
> > > > > > > > >>Lisa,
> > > > > > > > >>
> > > > > > > > >>You have backups? Restore from backup. Otherwise.....
> > recreate and import
> > > > > > > > >>is
> > > > > > > > >>the way to go.
> > > > > > > > >>
> > > > > > > > >>I gotta say, the fact that you did this, figured out how
to
> > fix it, and
> > > > > > > > >>didn't freak out about it, would impress me MUCH more on
an
> > interview than
> > > > > > > > >>the fact that you have your OCP :)
> > > > > > > > >>
> > > > > > > > >>Rachel
> > > > > > > > >>
> > > > > > > > >>
> > > > > > > > >> >From: Lisa_Koivu_at_gelco.com
> > > > > > > > >> >Reply-To: ORACLE-L_at_fatcity.com
> > > > > > > > >> >To: Multiple recipients of list ORACLE-L
> > <ORACLE-L_at_fatcity.com>
> > > > > > > > >> >Subject: Big Whoops
> > > > > > > > >> >Date: Wed, 24 May 2000 14:44:29 -0800
> > > > > > > > >> >
> > > > > > > > >> >This is by far the funniest thing I have ever done. I
> > began running the
> > > > > > > > >> >create
> > > > > > > > >> >database scripts (ON A TEST MACHINE) when the
$ORACLE_SID
> > was set to a
> > > > > > > > >> >currently
> > > > > > > > >> >running database. It's now completely and totally
hosed.
> > I'm just
> > > > > > > > >> >wondering if
> > > > > > > > >> >there is any possible way of recovering from this. I am
> > just recreating
> > > > > > > > >> >the
> > > > > > > > >> >database and reimporting the data - it's not a big deal,
> > but for future
> > > > > > > > >> >reference, I wonder if this really does mean THE END OF
> > THE DATABASE AS
> > > > > > > > >>WE
> > > > > > > > >> >KNOW
> > > > > > > > >> >IT. My gut feel is YES.
> > > > > > > > >> >
> > > > > > > > >> >I just can't stop laughing. I finish my OCP exams and
> > completely TRASH
> > > > > > > > >>a
> > > > > > > > >> >large
> > > > > > > > >> >database in the same day (and dump pink ice cream on my
> > white sweater
> > > > > > > > >> >simultaneously)! Like Kirti said, Who *WANTS* to be a
> > DBA? Are you out
> > > > > > > > >>of
> > > > > > > > >> >your
> > > > > > > > >> >mind? you better be!
> > > > > > > > >> >
> > > > > > > > >> >
> > > > > > > > >> >
> > > > > > > > >> >
> > > > > > > > >> >--
> > > > > > > > >> >Author:
> > > > > > > > >> > INET: Lisa_Koivu_at_gelco.com
> > > > > > > > >> >
> > > > > > > > >> >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: ListGuru_at_fatcity.com (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).
> > > > > > > > >>
> > > > > > > >
> >
>>________________________________________________________________________
> > > > > > > > >>Get Your Private, Free E-mail from MSN Hotmail at
> > http://www.hotmail.com
> > > > > > > > >>
> > > > > > > > >>--
> > > > > > > > >>Author: Rachel Carmichael
> > > > > > > > >> INET: carmichr_at_hotmail.com
> > > > > > > > >>
> > > > > > > > >>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: ListGuru_at_fatcity.com (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).
> > > > > > > > >>--
> > > > > > > > >>Author:
> > > > > > > > >> INET: dgoulet_at_vicr.com
> > > > > > > > >>
> > > > > > > > >>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: ListGuru_at_fatcity.com (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).
> > > > > > > > >
> > > > > > > >
> >
>________________________________________________________________________
> > > > > > > > >Get Your Private, Free E-mail from MSN Hotmail at
> > http://www.hotmail.com
> > > > > > > > >
> > > > > > > > >--
> > > > > > > > >Author: Steve Boyd
> > > > > > > > > INET: pimaco_oracle_at_hotmail.com
> > > > > > > > >
> > > > > > > > >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: ListGuru_at_fatcity.com (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).
> > > > > > > >
> > > > > > > >
> > ________________________________________________________________________
> > > > > > > > Get Your Private, Free E-mail from MSN Hotmail at
> > http://www.hotmail.com
> > > > > > > >
> > > > > > > > --
> > > > > > > > Author: Rachel Carmichael
> > > > > > > > INET: carmichr_at_hotmail.com
> > > > > > > >
> > > > > > > > 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: ListGuru_at_fatcity.com (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).
> > > > > > > >
> > > > > > >
> > > > > > > --
> > > > > > > Author: Ari D Kaplan
> > > > > > > INET: akaplan_at_interaccess.com
> > > > > > >
> > > > > > > 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: ListGuru_at_fatcity.com (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).
> > > > > > >
> > > > > >
> > > > > >
> > > > > > Jared Still
> > > > > > Certified Oracle DBA and Part Time Perl Evangelist ;-)
> > > > > > Regence BlueCross BlueShield of Oregon
> > > > > > jkstill_at_bcbso.com - Work - preferred address
> > > > > > jkstill_at_teleport.com - private
> > > > > >
> > > > > >
> > > > > > --
> > > > > > Author: Jared Still
> > > > > > INET: jkstill_at_bcbso.com
> > > > > >
> > > > > > 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: ListGuru_at_fatcity.com (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).
> > > > > >
> > > > >
> > > > > --
> > > > > Author: Ari D Kaplan
> > > > > INET: akaplan_at_interaccess.com
> > > > >
> > > > > Fat City Network Services -- (858) 538-5051 FAX: (858)
538-5051
> > > > > San Diego, California -- Public Internet access / Mailing
> > Lists
> > > > >
-- Author: Ari D Kaplan INET: akaplan_at_interaccess.com 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: ListGuru_at_fatcity.com (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). =================================================================== De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan. =================================================================== The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Ernst & Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. =================================================================== -- Author: Jack van Zanen INET: nlzanen1_at_ey.nl 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: ListGuru_at_fatcity.com (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). ------_=_NextPart_001_01BFCA62.46580FA0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0"> <TITLE>RE: Re[2]: Big Whoops</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>I think that the best way is to have a procedure = which can be called from glogin.sql, owned by sys and grant execute to = public - to get data from v$session and v$database. Also we can create = script in SQLPATH directory which will call glogin.sql, so every time = after entering connect user/password_at_alias one shoud run this script - = like @c</FONT></P> <P><FONT SIZE=3D2>Alex Hillman </FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Jack van Zanen [<A = HREF=3D"mailto:nlzanen1_at_ey.nl">mailto:nlzanen1_at_ey.nl</A>]</FONT> <BR><FONT SIZE=3D2>Sent: Tuesday, May 30, 2000 3:15 AM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: RE: Re[2]: Big Whoops</FONT> </P> <BR> <BR> <BR> <BR> <P><FONT SIZE=3D2>Hi</FONT> </P> <BR> <P><FONT SIZE=3D2>I created a little script called "c" and = placed it's location in the registry</FONT> <BR><FONT SIZE=3D2>sqlpath which I call to change the connection</FONT> </P> <P><FONT SIZE=3D2>*************</FONT> </P> <P><FONT SIZE=3D2>accept username prompt "Type username = :";</FONT> <BR><FONT SIZE=3D2>accept password prompt "Type Password (wordt = niet getoond) :" hide;</FONT> <BR><FONT SIZE=3D2>accept sid prompt "Type instance naam (SID) = :";</FONT> <BR><FONT SIZE=3D2>connect &username/&password@&sid;</FONT> <BR><FONT SIZE=3D2>@c:\orawin95\plus80\Glogin.sql;</FONT> <BR><FONT SIZE=3D2>undefine username;</FONT> <BR><FONT SIZE=3D2>undefine password;</FONT> <BR><FONT SIZE=3D2>undefine sid;</FONT> <BR><FONT SIZE=3D2>rem CLEAR SCREEN;</FONT> </P> <P><FONT SIZE=3D2>************</FONT> </P> <P><FONT SIZE=3D2>I always use this i.s.o. connect</FONT> </P> <BR> <BR> <P><FONT SIZE=3D2>Jack</FONT> </P> <BR> <BR> <BR> <P><FONT SIZE=3D2>Ari D Kaplan = <akaplan_at_interaccess.com>@fatcity.com on 05/30/2000 03:08:12 = AM</FONT> </P> <P><FONT SIZE=3D2>Please respond to ORACLE-L_at_fatcity.com</FONT> </P> <P><FONT SIZE=3D2>Sent by: root_at_fatcity.com</FONT> </P> <BR> <P><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L = <ORACLE-L_at_fatcity.com></FONT> <BR><FONT SIZE=3D2>cc:</FONT> </P> <BR> <P><FONT SIZE=3D2>Thanks Kirti for providing this in Oracle7.</FONT> </P> <P><FONT SIZE=3D2>One problem with this is if you are already connected = and issue:</FONT> </P> <P><FONT SIZE=3D2>connect username/password_at_DB_LINK;</FONT> </P> <P><FONT SIZE=3D2>I don't know how to get around that... if anyone out = there knows how to</FONT> <BR><FONT SIZE=3D2>refresh the prompt when you issue = "connect" that would be great.</FONT> </P> <BR> <P><FONT SIZE=3D2>Why are we doing this on a holiday? Well, I already = had my corn on the</FONT> <BR><FONT SIZE=3D2>cob, and the email is always on, so.....</FONT> </P> <P><FONT SIZE=3D2>Regards,</FONT> </P> <P><FONT SIZE=3D2>-Ari</FONT> <BR><FONT SIZE=3D2>www.arikaplan.com</FONT> </P> <P><FONT SIZE=3D2>On Mon, 29 May 2000, Deshpande, Kirti wrote:</FONT> </P> <P><FONT SIZE=3D2>> Here is one way to do this in Oracle 7 that I = know.. It shows the machine</FONT> <BR><FONT SIZE=3D2>> name and sid name just before the SQL> = prompt....</FONT> <BR><FONT SIZE=3D2>> However, the prompt won't change for remote = connections made from local the</FONT> <BR><FONT SIZE=3D2>> local connection.</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> set termout off</FONT> <BR><FONT SIZE=3D2>> col myprompt noprint new_value = myprompt_new</FONT> <BR><FONT SIZE=3D2>> SELECT 'SQL> ' myprompt from dual;</FONT> <BR><FONT SIZE=3D2>> SELECT substr(proc.program,</FONT> <BR><FONT SIZE=3D2>> = instr(proc.program,'@')+1,</FONT> <BR><FONT SIZE=3D2>> = instr(proc.program,' ') - instr(proc.program,'@')) ||</FONT> <BR><FONT SIZE=3D2>> '[' = || param.value ||</FONT> <BR><FONT SIZE=3D2>> '] = SQL> ' myprompt</FONT> <BR><FONT SIZE=3D2>> FROM v$process proc, v$parameter param</FONT> <BR><FONT SIZE=3D2>> WHERE param.name =3D 'db_name'</FONT> <BR><FONT SIZE=3D2>> AND proc.pid =3D 2;</FONT> <BR><FONT SIZE=3D2>> set sqlprompt '&&myprompt_new'</FONT> <BR><FONT SIZE=3D2>> /</FONT> <BR><FONT SIZE=3D2>> set termout on</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> HTH..</FONT> <BR><FONT SIZE=3D2>> - Kirti</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> > -----Original Message-----</FONT> <BR><FONT SIZE=3D2>> > From: Jared Still = [SMTP:jkstill_at_bcbso.com]</FONT> <BR><FONT SIZE=3D2>> > Sent: Monday, May 29, 2000 6:24 PM</FONT> <BR><FONT SIZE=3D2>> > To: Multiple recipients of = list ORACLE-L</FONT> <BR><FONT SIZE=3D2>> > Subject: Re: Re[2]: Big = Whoops</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> > Oops. I didn't scroll down and read = the</FONT> <BR><FONT SIZE=3D2>> > entire message. Sorry about = that.</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> > What I had in mind, but didn't say, ( the = SEND</FONT> <BR><FONT SIZE=3D2>> > key is faster than the brain ) was in = regards</FONT> <BR><FONT SIZE=3D2>> > to version 7 databases.</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> > I used to pull the machine name out of = MTS</FONT> <BR><FONT SIZE=3D2>> > configuration info, but we don't use MTS = here.</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> > Any idea how to do this in 7.x = databases?</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> > Thanks</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> > Jared</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> > P.S. Why are we doing this on a = holiday?</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> > On Mon, 29 May 2000, Ari D Kaplan = wrote:</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> > > I believe the example shows how to = embed the machine name.</FONT> <BR><FONT SIZE=3D2>> > ></FONT> <BR><FONT SIZE=3D2>> > > SELECT 'set sqlprompt '''|| d.name = ||'@' ||</FONT> <BR><FONT SIZE=3D2>> > > = substr(s.machine,1,decode (instr(s.machine,'.'), 0,</FONT> <BR><FONT SIZE=3D2>> > length(s.machine),</FONT> <BR><FONT SIZE=3D2>> > > = instr(s.machine,'.') - 1)) ||</FONT> <BR><FONT SIZE=3D2>> > > '-SQL> = '''</FONT> <BR><FONT SIZE=3D2>> > > FROM V$SESSION s, V$DATABASE D</FONT> <BR><FONT SIZE=3D2>> > > WHERE s.SID=3D1;</FONT> <BR><FONT SIZE=3D2>> > ></FONT> <BR><FONT SIZE=3D2>> > > The output will look like:</FONT> <BR><FONT SIZE=3D2>> > > set sqlprompt 'PHIS_at_survlpd-SQL> = '</FONT> <BR><FONT SIZE=3D2>> > ></FONT> <BR><FONT SIZE=3D2>> > ></FONT> <BR><FONT SIZE=3D2>> > > In the above example, = "survlpd" is the machine name.</FONT> <BR><FONT SIZE=3D2>> > ></FONT> <BR><FONT SIZE=3D2>> > > -Ari</FONT> <BR><FONT SIZE=3D2>> > > www.arikaplan.com</FONT> <BR><FONT SIZE=3D2>> > > On Mon, 29 May 2000, Jared Still = wrote:</FONT> <BR><FONT SIZE=3D2>> > ></FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > In that case, maybe you could = provide various methods</FONT> <BR><FONT SIZE=3D2>> > > > of embedding the machine name in = the SQL prompt as well.</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > Jared</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > On Sat, 27 May 2000, Ari D = Kaplan wrote:</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > > I do the SQL prompt change = as well... for the listers benefit I am</FONT> <BR><FONT SIZE=3D2>> > > > > providing part of my = upcoming EOUG speech (how many of you really</FONT> <BR><FONT SIZE=3D2>> > are</FONT> <BR><FONT SIZE=3D2>> > > > > coming?) that explains how = to do this...</FONT> <BR><FONT SIZE=3D2>> > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > -Ari</FONT> <BR><FONT SIZE=3D2>> > > > > www.arikaplan.com</FONT> <BR><FONT SIZE=3D2>> > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > When you first get your = Oracle CD-ROM, install and create your</FONT> <BR><FONT SIZE=3D2>> > database,</FONT> <BR><FONT SIZE=3D2>> > > > > and go to SQL*Plus, you are = greeted with the familiar "SQL>" prompt.</FONT> <BR><FONT SIZE=3D2>> > What</FONT> <BR><FONT SIZE=3D2>> > > > > many Oracle professionals = do not know is that this prompt can be</FONT> <BR><FONT SIZE=3D2>> > changed.</FONT> <BR><FONT SIZE=3D2>> > > > > It could be useful to have = the prompt give the time, the username,</FONT> <BR><FONT SIZE=3D2>> > which</FONT> <BR><FONT SIZE=3D2>> > > > > machine you are on, or any = other information particular to an</FONT> <BR><FONT SIZE=3D2>> > application.</FONT> <BR><FONT SIZE=3D2>> > > > > The prompt is most easily = changed by modifying the global or local</FONT> <BR><FONT SIZE=3D2>> > login</FONT> <BR><FONT SIZE=3D2>> > > > > scripts. The global login = script, which is the</FONT> <BR><FONT SIZE=3D2>> > > > > = $ORACLE_HOME/sqlplus/admin/glogin.sql file, gets run when anyone</FONT> <BR><FONT SIZE=3D2>> > connects</FONT> <BR><FONT SIZE=3D2>> > > > > to the database. It is here = that you can put in SQL to control what</FONT> <BR><FONT SIZE=3D2>> > > > > happens when a user invokes = SQL*Plus. Common commands are formatting</FONT> <BR><FONT SIZE=3D2>> > of</FONT> <BR><FONT SIZE=3D2>> > > > > columns, setting PAGESIZE, = putting in messages, changing optimizer</FONT> <BR><FONT SIZE=3D2>> > goals,</FONT> <BR><FONT SIZE=3D2>> > > > > or changing the prompt. For = example:</FONT> <BR><FONT SIZE=3D2>> > > > > set heading off</FONT> <BR><FONT SIZE=3D2>> > > > > select 'Logged in as ' || = username from user_users;</FONT> <BR><FONT SIZE=3D2>> > > > > set heading on</FONT> <BR><FONT SIZE=3D2>> > > > > will print "Logged in = as SCOTT" when you connect as SCOTT.</FONT> <BR><FONT SIZE=3D2>> > > > > If there is a file in = $ORACLE_PATH called "login.sql", it is</FONT> <BR><FONT SIZE=3D2>> > referred to</FONT> <BR><FONT SIZE=3D2>> > > > > as a local login script. = This will override the global login script.</FONT> <BR><FONT SIZE=3D2>> > If</FONT> <BR><FONT SIZE=3D2>> > > > > you use local or global = login scripts, you can change the SQL</FONT> <BR><FONT SIZE=3D2>> > prompt.</FONT> <BR><FONT SIZE=3D2>> > > > > SELECT 'set sqlprompt '''|| = d.name ||'@' ||</FONT> <BR><FONT SIZE=3D2>> > > > > substr(s.machine,1,decode = (instr(s.machine,'.'), 0,</FONT> <BR><FONT SIZE=3D2>> > length(s.machine),</FONT> <BR><FONT SIZE=3D2>> > > > > instr(s.machine,'.') - 1)) = ||</FONT> <BR><FONT SIZE=3D2>> > > > > '-SQL> '''</FONT> <BR><FONT SIZE=3D2>> > > > > FROM V$SESSION s, = V$DATABASE D</FONT> <BR><FONT SIZE=3D2>> > > > > WHERE s.SID=3D1;</FONT> <BR><FONT SIZE=3D2>> > > > > The output will look = like:</FONT> <BR><FONT SIZE=3D2>> > > > > set sqlprompt = 'PHIS_at_survlpd-SQL> '</FONT> <BR><FONT SIZE=3D2>> > > > > This will use the "SET = SQLPROMPT" command to be the instance name</FONT> <BR><FONT SIZE=3D2>> > and the</FONT> <BR><FONT SIZE=3D2>> > > > > server name. For this to = work, you will need to spool the result of</FONT> <BR><FONT SIZE=3D2>> > the</FONT> <BR><FONT SIZE=3D2>> > > > > SELECT clause to a file, = and then run the file. Putting it all</FONT> <BR><FONT SIZE=3D2>> > together:</FONT> <BR><FONT SIZE=3D2>> > > > > set heading off</FONT> <BR><FONT SIZE=3D2>> > > > > set prompt off</FONT> <BR><FONT SIZE=3D2>> > > > > spool = make_prompt.sql</FONT> <BR><FONT SIZE=3D2>> > > > > SELECT 'set sqlprompt '''|| = d.name ||'@' ||</FONT> <BR><FONT SIZE=3D2>> > > > > substr(s.machine,1,decode = (instr(s.machine,'.'), 0,</FONT> <BR><FONT SIZE=3D2>> > length(s.machine),</FONT> <BR><FONT SIZE=3D2>> > > > > instr(s.machine,'.') - 1)) = ||</FONT> <BR><FONT SIZE=3D2>> > > > > '-SQL> '''</FONT> <BR><FONT SIZE=3D2>> > > > > FROM V$SESSION s, = V$DATABASE D</FONT> <BR><FONT SIZE=3D2>> > > > > WHERE s.SID=3D1;</FONT> <BR><FONT SIZE=3D2>> > > > > spool off</FONT> <BR><FONT SIZE=3D2>> > > > > @make_prompt.sql</FONT> <BR><FONT SIZE=3D2>> > > > > set heading on</FONT> <BR><FONT SIZE=3D2>> > > > > set feedback on</FONT> <BR><FONT SIZE=3D2>> > > > > You will now have a nice = prompt each time you connect. With multiple</FONT> <BR><FONT SIZE=3D2>> > > > > windows open on your = computer, this is a good way to keep track of</FONT> <BR><FONT SIZE=3D2>> > which</FONT> <BR><FONT SIZE=3D2>> > > > > database each window is = connect to.</FONT> <BR><FONT SIZE=3D2>> > > > ></FONT> <BR><FONT SIZE=3D2>> > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > On Sat, 27 May 2000, Jared = Still wrote:</FONT> <BR><FONT SIZE=3D2>> > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > > Since then I = color-code my windows (light red on black for</FONT> <BR><FONT SIZE=3D2>> > production</FONT> <BR><FONT SIZE=3D2>> > > > > > > = windows)...</FONT> <BR><FONT SIZE=3D2>> > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > This seems to work for = some people. A fellow DBA here at</FONT> <BR><FONT SIZE=3D2>> > > > > > Blue Cross does = this.</FONT> <BR><FONT SIZE=3D2>> > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > It never seemed to = work for me. Embedding the database name</FONT> <BR><FONT SIZE=3D2>> > > > > > in the SQL prompt = seems to work best, at least for me.</FONT> <BR><FONT SIZE=3D2>> > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > Jared</FONT> <BR><FONT SIZE=3D2>> > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > > Steve, Rachel - = you are not alone...</FONT> <BR><FONT SIZE=3D2>> > > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > > -Ari</FONT> <BR><FONT SIZE=3D2>> > > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > > On Thu, 25 May = 2000, Rachel Carmichael wrote:</FONT> <BR><FONT SIZE=3D2>> > > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > > > = me....</FONT> <BR><FONT SIZE=3D2>> > > > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > > > logged into = two terminals, one was production, one was test.</FONT> <BR><FONT SIZE=3D2>> > In both the</FONT> <BR><FONT SIZE=3D2>> > > > > > > > tablespaces = had the same names. So I think I am going to drop</FONT> <BR><FONT SIZE=3D2>> > the two</FONT> <BR><FONT SIZE=3D2>> > > > > > > > tablespaces = in test, so I can recreate from production.</FONT> <BR><FONT SIZE=3D2>> > > > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > > > I do alter = tablespace <xxx> offline;</FONT> <BR><FONT SIZE=3D2>> > > > > > > > drop = tablespace <xxx> including contents;</FONT> <BR><FONT SIZE=3D2>> > > > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > > > and then = scream as I realize I dropped a production</FONT> <BR><FONT SIZE=3D2>> > tablespace. I go into my</FONT> <BR><FONT SIZE=3D2>> > > > > > > > user's = office and tell him he can kill me later, this is what</FONT> <BR><FONT SIZE=3D2>> > I did, how</FONT> <BR><FONT SIZE=3D2>> > > > > > > > does he want = me to proceed to fix it. fortunately the</FONT> <BR><FONT SIZE=3D2>> > production one was</FONT> <BR><FONT SIZE=3D2>> > > > > > > > static data, = and could be recreated. we do so.</FONT> <BR><FONT SIZE=3D2>> > > > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > > > he then = tells me I have used up all my screw-ups for the next</FONT> <BR><FONT SIZE=3D2>> > 5 years.</FONT> <BR><FONT SIZE=3D2>> > > > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > > > everyone = does stupid stuff. the trick is to admit it and know</FONT> <BR><FONT SIZE=3D2>> > how to recover</FONT> <BR><FONT SIZE=3D2>> > > > > > > > from = it</FONT> <BR><FONT SIZE=3D2>> > > > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > > > = Rachel</FONT> <BR><FONT SIZE=3D2>> > > > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > > > >From: = "Steve Boyd" <pimaco_oracle_at_hotmail.com></FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >Reply-To: ORACLE-L_at_fatcity.com</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >To: = Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>> > <ORACLE-L_at_fatcity.com></FONT> <BR><FONT SIZE=3D2>> > > > > > > > >Subject: = Re: Re[2]: Big Whoops</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >Date: = Thu, 25 May 2000 07:38:38 -0800</FONT> <BR><FONT SIZE=3D2>> > > > > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > > > >I'd like = to post a question for everyone on the list.</FONT> <BR><FONT SIZE=3D2>> > > > > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > > > >How many = of you have ever dropped a table, or done something</FONT> <BR><FONT SIZE=3D2>> > like that in</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >the = wrong database(thinking you were connected to say the</FONT> <BR><FONT SIZE=3D2>> > test DB), and</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >hosed = production?</FONT> <BR><FONT SIZE=3D2>> > > > > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > > > >Steve = Boyd</FONT> <BR><FONT SIZE=3D2>> > > > > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>From: dgoulet_at_vicr.com</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>Reply-To: ORACLE-L_at_fatcity.com</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >>To: = Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>> > <ORACLE-L_at_fatcity.com></FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>Subject: Re[2]: Big Whoops</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>Date: Thu, 25 May 2000 06:40:46 -0800</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >></FONT> <BR><FONT SIZE=3D2>> > > > > > > > >>A = couple of years ago I was trying to create a new instance</FONT> <BR><FONT SIZE=3D2>> > on one of our</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>Unix</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>boxes to support an additional manufacturing line. = Since</FONT> <BR><FONT SIZE=3D2>> > the first</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>instance was</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >>well = tuned, I copied the init.ora file to a new name & did</FONT> <BR><FONT SIZE=3D2>> > the little</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>editing</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >>that = I believed necessary, like a new db_name. What I</FONT> <BR><FONT SIZE=3D2>> > forgot was the</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>control_file line. You can guess what happen next, yes = the</FONT> <BR><FONT SIZE=3D2>> > control files</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>got</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>trashed and the original instance terminated with = errors.</FONT> <BR><FONT SIZE=3D2>> > We had to</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>recover</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >>that = one from tape since I hadn't backed up the control</FONT> <BR><FONT SIZE=3D2>> > files to trace for</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>some</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>time, but I do now at every shutdown. We live & learn = from</FONT> <BR><FONT SIZE=3D2>> > our mistakes,</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>hopefully NOT on a production server.</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >></FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >></FONT> <BR><FONT SIZE=3D2>> > > > > > > > >>BTW: = My advice to any new DBA out there is that when an</FONT> <BR><FONT SIZE=3D2>> > emergency hits</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>you,</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>or</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >>an = AW SH%$. First step in the process is to step back, take</FONT> <BR><FONT SIZE=3D2>> > a deep breath</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>&</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >>calm = down. Adrenaline and instant reaction are your worst</FONT> <BR><FONT SIZE=3D2>> > enemies.</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >></FONT> <BR><FONT SIZE=3D2>> > > > > > > > >>Dick = Goulet</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>Senior Oracle DBA</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>Vicor Corporation</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >></FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>____________________Reply Separator____________________</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>Author: "Rachel Carmichael" = <carmichr_at_hotmail.com></FONT> <BR><FONT SIZE=3D2>> > > > > > > > >>Date:= 5/24/00 6:16 PM</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >></FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>Lisa,</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >></FONT> <BR><FONT SIZE=3D2>> > > > > > > > >>You = have backups? Restore from backup. Otherwise.....</FONT> <BR><FONT SIZE=3D2>> > recreate and import</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>is</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >>the = way to go.</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >></FONT> <BR><FONT SIZE=3D2>> > > > > > > > >>I = gotta say, the fact that you did this, figured out how to</FONT> <BR><FONT SIZE=3D2>> > fix it, and</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>didn't freak out about it, would impress me MUCH more on = an</FONT> <BR><FONT SIZE=3D2>> > interview than</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >>the = fact that you have your OCP :)</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >></FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>Rachel</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >></FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >></FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >From: Lisa_Koivu_at_gelco.com</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >Reply-To: ORACLE-L_at_fatcity.com</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>> > <ORACLE-L_at_fatcity.com></FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >Subject: Big Whoops</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >Date: Wed, 24 May 2000 14:44:29 -0800</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = ></FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >This is by far the funniest thing I have ever done. I</FONT> <BR><FONT SIZE=3D2>> > began running the</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >create</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >database scripts (ON A TEST MACHINE) when the $ORACLE_SID</FONT> <BR><FONT SIZE=3D2>> > was set to a</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >currently</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >running database. It's now completely and totally = hosed.</FONT> <BR><FONT SIZE=3D2>> > I'm just</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >wondering if</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >there is any possible way of recovering from this. I = am</FONT> <BR><FONT SIZE=3D2>> > just recreating</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >the</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >database and reimporting the data - it's not a big deal,</FONT> <BR><FONT SIZE=3D2>> > but for future</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >reference, I wonder if this really does mean THE END OF</FONT> <BR><FONT SIZE=3D2>> > THE DATABASE AS</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>WE</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >KNOW</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >IT. My gut feel is YES.</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = ></FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >I just can't stop laughing. I finish my OCP exams and</FONT> <BR><FONT SIZE=3D2>> > completely TRASH</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>a</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >large</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >database in the same day (and dump pink ice cream on my</FONT> <BR><FONT SIZE=3D2>> > white sweater</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >simultaneously)! Like Kirti said, Who *WANTS* to be a</FONT> <BR><FONT SIZE=3D2>> > DBA? Are you out</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>of</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >your</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >mind? you better be!</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = ></FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = ></FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = ></FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = ></FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >--</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >Author:</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = > INET: Lisa_Koivu_at_gelco.com</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = ></FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >Fat City Network Services -- (858) 538-5051 = FAX: (858)</FONT> <BR><FONT SIZE=3D2>> > 538-5051</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >San Diego, California -- = Public Internet access /</FONT> <BR><FONT SIZE=3D2>> > Mailing Lists</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >></FONT> <BR><FONT SIZE=3D2>> > = >--------------------------------------------------------------------= </FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >To REMOVE yourself from this mailing list, send an E-Mail</FONT> <BR><FONT SIZE=3D2>> > message</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >to: ListGuru_at_fatcity.com (note EXACT spelling of</FONT> <BR><FONT SIZE=3D2>> > 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >the message BODY, include a line containing: UNSUB</FONT> <BR><FONT SIZE=3D2>> > ORACLE-L</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >(or the name of mailing list you want to be removed from).</FONT> <BR><FONT SIZE=3D2>> > You may</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >> = >also send the HELP command for other information (like</FONT> <BR><FONT SIZE=3D2>> > subscribing).</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >></FONT> <BR><FONT SIZE=3D2>> > > > > > > ></FONT> <BR><FONT SIZE=3D2>> > = >>________________________________________________________________= ________</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >>Get = Your Private, Free E-mail from MSN Hotmail at</FONT> <BR><FONT SIZE=3D2>> > <A HREF=3D"http://www.hotmail.com" = TARGET=3D"_blank">http://www.hotmail.com</A></FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >></FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>--</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>Author: Rachel Carmichael</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >> INET: carmichr_at_hotmail.com</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >></FONT> <BR><FONT SIZE=3D2>> > > > > > > > >>Fat = City Network Services -- (858) 538-5051 FAX: = (858)</FONT> <BR><FONT SIZE=3D2>> > 538-5051</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >>San = Diego, California -- Public = Internet access /</FONT> <BR><FONT SIZE=3D2>> > Mailing Lists</FONT> <BR><FONT SIZE=3D2>> > > > > > > ></FONT> <BR><FONT SIZE=3D2>> > = >>----------------------------------------------------------------= ----</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >>To = REMOVE yourself from this mailing list, send an E-Mail</FONT> <BR><FONT SIZE=3D2>> > message</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >>to: = ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')</FONT> <BR><FONT SIZE=3D2>> > and in</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >>the = message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >>(or = the name of mailing list you want to be removed from).</FONT> <BR><FONT SIZE=3D2>> > You may</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >>also = send the HELP command for other information (like</FONT> <BR><FONT SIZE=3D2>> > subscribing).</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>--</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >>Author:</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >> INET: dgoulet_at_vicr.com</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >></FONT> <BR><FONT SIZE=3D2>> > > > > > > > >>Fat = City Network Services -- (858) 538-5051 FAX: = (858)</FONT> <BR><FONT SIZE=3D2>> > 538-5051</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >>San = Diego, California -- Public = Internet access /</FONT> <BR><FONT SIZE=3D2>> > Mailing Lists</FONT> <BR><FONT SIZE=3D2>> > > > > > > ></FONT> <BR><FONT SIZE=3D2>> > = >>----------------------------------------------------------------= ----</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >>To = REMOVE yourself from this mailing list, send an E-Mail</FONT> <BR><FONT SIZE=3D2>> > message</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >>to: = ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')</FONT> <BR><FONT SIZE=3D2>> > and in</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >>the = message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >>(or = the name of mailing list you want to be removed from).</FONT> <BR><FONT SIZE=3D2>> > You may</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >>also = send the HELP command for other information (like</FONT> <BR><FONT SIZE=3D2>> > subscribing).</FONT> <BR><FONT SIZE=3D2>> > > > > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > > ></FONT> <BR><FONT SIZE=3D2>> > = >____________________________________________________________________= ____</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >Get Your = Private, Free E-mail from MSN Hotmail at</FONT> <BR><FONT SIZE=3D2>> > <A HREF=3D"http://www.hotmail.com" = TARGET=3D"_blank">http://www.hotmail.com</A></FONT> <BR><FONT SIZE=3D2>> > > > > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > > > = >--</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >Author: = Steve Boyd</FONT> <BR><FONT SIZE=3D2>> > > > > > > > > = INET: pimaco_oracle_at_hotmail.com</FONT> <BR><FONT SIZE=3D2>> > > > > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > > > >Fat City = Network Services -- (858) 538-5051 FAX: = (858)</FONT> <BR><FONT SIZE=3D2>> > 538-5051</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >San = Diego, California -- Public = Internet access /</FONT> <BR><FONT SIZE=3D2>> > Mailing Lists</FONT> <BR><FONT SIZE=3D2>> > > > > > > ></FONT> <BR><FONT SIZE=3D2>> > = >--------------------------------------------------------------------= </FONT> <BR><FONT SIZE=3D2>> > > > > > > > >To = REMOVE yourself from this mailing list, send an E-Mail</FONT> <BR><FONT SIZE=3D2>> > message</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >to: = ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')</FONT> <BR><FONT SIZE=3D2>> > and in</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >the = message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >(or the = name of mailing list you want to be removed from).</FONT> <BR><FONT SIZE=3D2>> > You may</FONT> <BR><FONT SIZE=3D2>> > > > > > > > >also = send the HELP command for other information (like</FONT> <BR><FONT SIZE=3D2>> > subscribing).</FONT> <BR><FONT SIZE=3D2>> > > > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > > ></FONT> <BR><FONT SIZE=3D2>> > = ________________________________________________________________________= </FONT> <BR><FONT SIZE=3D2>> > > > > > > > Get Your = Private, Free E-mail from MSN Hotmail at</FONT> <BR><FONT SIZE=3D2>> > <A HREF=3D"http://www.hotmail.com" = TARGET=3D"_blank">http://www.hotmail.com</A></FONT> <BR><FONT SIZE=3D2>> > > > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > > > --</FONT> <BR><FONT SIZE=3D2>> > > > > > > > Author: = Rachel Carmichael</FONT> <BR><FONT SIZE=3D2>> > > > > > > > = INET: carmichr_at_hotmail.com</FONT> <BR><FONT SIZE=3D2>> > > > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > > > Fat City = Network Services -- (858) 538-5051 FAX: = (858)</FONT> <BR><FONT SIZE=3D2>> > 538-5051</FONT> <BR><FONT SIZE=3D2>> > > > > > > > San Diego, = California -- Public Internet = access /</FONT> <BR><FONT SIZE=3D2>> > Mailing Lists</FONT> <BR><FONT SIZE=3D2>> > > > > > > ></FONT> <BR><FONT SIZE=3D2>> > = --------------------------------------------------------------------</FO= NT> <BR><FONT SIZE=3D2>> > > > > > > > To REMOVE = yourself from this mailing list, send an E-Mail</FONT> <BR><FONT SIZE=3D2>> > message</FONT> <BR><FONT SIZE=3D2>> > > > > > > > to: = ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')</FONT> <BR><FONT SIZE=3D2>> > and in</FONT> <BR><FONT SIZE=3D2>> > > > > > > > the message = BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>> > > > > > > > (or the name = of mailing list you want to be removed from).</FONT> <BR><FONT SIZE=3D2>> > You may</FONT> <BR><FONT SIZE=3D2>> > > > > > > > also send = the HELP command for other information (like</FONT> <BR><FONT SIZE=3D2>> > subscribing).</FONT> <BR><FONT SIZE=3D2>> > > > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > > --</FONT> <BR><FONT SIZE=3D2>> > > > > > > Author: Ari D = Kaplan</FONT> <BR><FONT SIZE=3D2>> > > > > > > INET: = akaplan_at_interaccess.com</FONT> <BR><FONT SIZE=3D2>> > > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > > Fat City Network = Services -- (858) 538-5051 FAX: (858)</FONT> <BR><FONT SIZE=3D2>> > 538-5051</FONT> <BR><FONT SIZE=3D2>> > > > > > > San Diego, = California -- Public Internet = access / Mailing</FONT> <BR><FONT SIZE=3D2>> > Lists</FONT> <BR><FONT SIZE=3D2>> > > > > > ></FONT> <BR><FONT SIZE=3D2>> > = --------------------------------------------------------------------</FO= NT> <BR><FONT SIZE=3D2>> > > > > > > To REMOVE = yourself from this mailing list, send an E-Mail</FONT> <BR><FONT SIZE=3D2>> > message</FONT> <BR><FONT SIZE=3D2>> > > > > > > to: = ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and</FONT> <BR><FONT SIZE=3D2>> > in</FONT> <BR><FONT SIZE=3D2>> > > > > > > the message BODY, = include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>> > > > > > > (or the name of = mailing list you want to be removed from). You</FONT> <BR><FONT SIZE=3D2>> > may</FONT> <BR><FONT SIZE=3D2>> > > > > > > also send the = HELP command for other information (like</FONT> <BR><FONT SIZE=3D2>> > subscribing).</FONT> <BR><FONT SIZE=3D2>> > > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > Jared Still</FONT> <BR><FONT SIZE=3D2>> > > > > > Certified Oracle DBA = and Part Time Perl Evangelist ;-)</FONT> <BR><FONT SIZE=3D2>> > > > > > Regence BlueCross = BlueShield of Oregon</FONT> <BR><FONT SIZE=3D2>> > > > > > jkstill_at_bcbso.com - = Work - preferred address</FONT> <BR><FONT SIZE=3D2>> > > > > > jkstill_at_teleport.com - = private</FONT> <BR><FONT SIZE=3D2>> > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > --</FONT> <BR><FONT SIZE=3D2>> > > > > > Author: Jared = Still</FONT> <BR><FONT SIZE=3D2>> > > > > > INET: = jkstill_at_bcbso.com</FONT> <BR><FONT SIZE=3D2>> > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > > Fat City Network = Services -- (858) 538-5051 FAX: (858)</FONT> <BR><FONT SIZE=3D2>> > 538-5051</FONT> <BR><FONT SIZE=3D2>> > > > > > San Diego, = California -- Public Internet = access / Mailing</FONT> <BR><FONT SIZE=3D2>> > Lists</FONT> <BR><FONT SIZE=3D2>> > > > > ></FONT> <BR><FONT SIZE=3D2>> > = --------------------------------------------------------------------</FO= NT> <BR><FONT SIZE=3D2>> > > > > > To REMOVE yourself = from this mailing list, send an E-Mail message</FONT> <BR><FONT SIZE=3D2>> > > > > > to: = ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and</FONT> <BR><FONT SIZE=3D2>> > in</FONT> <BR><FONT SIZE=3D2>> > > > > > the message BODY, = include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>> > > > > > (or the name of = mailing list you want to be removed from). You</FONT> <BR><FONT SIZE=3D2>> > may</FONT> <BR><FONT SIZE=3D2>> > > > > > also send the HELP = command for other information (like</FONT> <BR><FONT SIZE=3D2>> > subscribing).</FONT> <BR><FONT SIZE=3D2>> > > > > ></FONT> <BR><FONT SIZE=3D2>> > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > --</FONT> <BR><FONT SIZE=3D2>> > > > > Author: Ari D Kaplan</FONT> <BR><FONT SIZE=3D2>> > > > > INET: = akaplan_at_interaccess.com</FONT> <BR><FONT SIZE=3D2>> > > > ></FONT> <BR><FONT SIZE=3D2>> > > > > Fat City Network = Services -- (858) 538-5051 FAX: (858) = 538-5051</FONT> <BR><FONT SIZE=3D2>> > > > > San Diego, = California -- Public Internet = access / Mailing</FONT> <BR><FONT SIZE=3D2>> > Lists</FONT> <BR><FONT SIZE=3D2>> > > > > = --------------------------------------------------------------------</FO= NT> <BR><FONT SIZE=3D2>> > > > > To REMOVE yourself from = this mailing list, send an E-Mail message</FONT> <BR><FONT SIZE=3D2>> > > > > to: ListGuru_at_fatcity.com = (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>> > > > > the message BODY, include a = line containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>> > > > > (or the name of mailing = list you want to be removed from). You may</FONT> <BR><FONT SIZE=3D2>> > > > > also send the HELP command = for other information (like subscribing).</FONT> <BR><FONT SIZE=3D2>> > > > ></FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > > Jared Still</FONT> <BR><FONT SIZE=3D2>> > > > Certified Oracle DBA and Part = Time Perl Evangelist ;-)</FONT> <BR><FONT SIZE=3D2>> > > > Regence BlueCross BlueShield of = Oregon</FONT> <BR><FONT SIZE=3D2>> > > > jkstill_at_bcbso.com - Work - = preferred address</FONT> <BR><FONT SIZE=3D2>> > > > jkstill_at_teleport.com - = private</FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > > ></FONT> <BR><FONT SIZE=3D2>> > ></FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> > Jared Still</FONT> <BR><FONT SIZE=3D2>> > Certified Oracle DBA and Part Time Perl = Evangelist ;-)</FONT> <BR><FONT SIZE=3D2>> > Regence BlueCross BlueShield of = Oregon</FONT> <BR><FONT SIZE=3D2>> > jkstill_at_bcbso.com - Work - preferred = address</FONT> <BR><FONT SIZE=3D2>> > jkstill_at_teleport.com - private</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> > --</FONT> <BR><FONT SIZE=3D2>> > Author: Jared Still</FONT> <BR><FONT SIZE=3D2>> > INET: jkstill_at_bcbso.com</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> > Fat City Network = Services -- (858) 538-5051 FAX: (858) = 538-5051</FONT> <BR><FONT SIZE=3D2>> > San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT SIZE=3D2>> > = --------------------------------------------------------------------</FO= NT> <BR><FONT SIZE=3D2>> > To REMOVE yourself from this mailing list, = send an E-Mail message</FONT> <BR><FONT SIZE=3D2>> > to: ListGuru_at_fatcity.com (note EXACT = spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>> > the message BODY, include a line = containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>> > (or the name of mailing list you want to = be removed from). You may</FONT> <BR><FONT SIZE=3D2>> > also send the HELP command for other = information (like subscribing).</FONT> <BR><FONT SIZE=3D2>> --</FONT> <BR><FONT SIZE=3D2>> Author: Deshpande, Kirti</FONT> <BR><FONT SIZE=3D2>> INET: = Kirti.Deshpande_at_gtedc.gte.com</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> Fat City Network Services -- = (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>> San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT SIZE=3D2>> = --------------------------------------------------------------------</FO= NT> <BR><FONT SIZE=3D2>> To REMOVE yourself from this mailing list, send = an E-Mail message</FONT> <BR><FONT SIZE=3D2>> to: ListGuru_at_fatcity.com (note EXACT spelling = of 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>> the message BODY, include a line containing: = UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>> (or the name of mailing list you want to be = removed from). You may</FONT> <BR><FONT SIZE=3D2>> also send the HELP command for other = information (like subscribing).</FONT> <BR><FONT SIZE=3D2>></FONT> </P> <P><FONT SIZE=3D2>--</FONT> <BR><FONT SIZE=3D2>Author: Ari D Kaplan</FONT> <BR><FONT SIZE=3D2> INET: akaplan_at_interaccess.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed = from). You may</FONT> <BR><FONT SIZE=3D2>also send the HELP command for other information = (like subscribing).</FONT> </P> <BR> <BR> <BR> <BR> <P><FONT = SIZE=3D2>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT=Received on Tue May 30 2000 - 13:10:02 CDT
>
<BR><FONT SIZE=3D2>De informatie verzonden met dit E-mail bericht is = uitsluitend bestemd voor</FONT> <BR><FONT SIZE=3D2>de geadresseerde. Gebruik van deze informatie door = anderen dan de</FONT> <BR><FONT SIZE=3D2>geadresseerde is verboden. Openbaarmaking, = vermenigvuldiging, verspreiding</FONT> <BR><FONT SIZE=3D2>en/of verstrekking van deze informatie aan derden is = niet toegestaan.</FONT> <BR><FONT SIZE=3D2>Ernst & Young staat niet in voor de juiste en = volledige overbrenging van de</FONT> <BR><FONT SIZE=3D2>inhoud van een verzonden E-mail, noch voor tijdige = ontvangst daarvan.</FONT> <BR><FONT = SIZE=3D2>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT=
>
<BR><FONT SIZE=3D2>The information contained in this communication is = confidential and may be</FONT> <BR><FONT SIZE=3D2>legally privileged. It is intended solely for the = use of the individual or</FONT> <BR><FONT SIZE=3D2>entity to whom it is addressed and others authorised = to receive it. If you</FONT> <BR><FONT SIZE=3D2>are not the intended recipient you are hereby =
 |
 |