RE: Customize my SQLPlus login

You don't. It's a habit you have to get into. And it only works if you haven't changed your directory. Like I said you can have another script that has login commands

(INV-SYSTEM)>@elvis
Enter password: *****
Connected.
(INV-ELVIS)> My @elvis script is simply this

connect elvis_at_inv
@login

I can set you up at Hotel Koivu in Ft. Lauderdale for a "cheap" rate in the dogs & cat room. We feature an outdoor pool that is near 80 degrees, tivo, access to antique convertible autos and DSL... but watch out for the very crabby housekeeper :)

Lisa Koivu
Oracle Database Tank.
Fairfield Resorts, Inc.
954-935-4117

> -----Original Message-----
> From: Grabowy, Chris [SMTP:cgrabowy_at_fcg.com]
> Sent: Tuesday, March 26, 2002 1:39 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Customize my SQLPlus login
>
> How do you know you ran the login script?? Maybe you forgot? And your
> really on production...when your about to truncate that table...that's
> unrecoverable...that's billions of rows....with hundreds of recent
> Fairfield
> customer reservations...that will be very upset...
>
> BTW, any chance you can "slip" me into the system, for a paid hotel
> reservation in Miami for a couple of days?
>
> -----Original Message-----
> Sent: Tuesday, March 26, 2002 1:19 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Nothing happens, the prompt stays the same unless you run @login, which I
> do
> to keep my head straight
>
> (INV-SYSTEM)>show user
> USER is "SYSTEM"
> (INV-SYSTEM)>connect elvis_at_inv
> Enter password: *****
> Connected.
> (INV-SYSTEM)>@login
> (INV-ELVIS)>
>
> or create a script with the login name and sid that calls login.sql right
> afterwards.
>
> Lisa Koivu
> Oracle Database Baby Oven.
> Fairfield Resorts, Inc.
> 954-935-4117
>
>
>
>
> > -----Original Message-----
> > From: Boivin, Patrice J [SMTP:BoivinP_at_mar.dfo-mpo.gc.ca]
> > Sent: Tuesday, March 26, 2002 12:24 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Customize my SQLPlus login
> >
> > What happens if the user then issues a connect statement to connect to
> > another database?
> >
> > It would be nice if there was a .sql file run every time a new
> connection
> > is
> > set, I don't know if that is the case in the 8i / 9i versions.
> >
> > Regards,
> > Patrice Boivin
> > Systems Analyst (Oracle Certified DBA)
> >
> > -----Original Message-----
> > Sent: Tuesday, March 26, 2002 10:23 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Customize my SQLPlus login
> >
> >
> > in your oracle /bin directory - you need to alter (Or create) a
> login.sql
> > file
> >
> > here's what mine looks like - feel free to alter
> >
> > /* **** start **** */
> > set heading on
> > set pause off
> > set pages 23
> > set lines 100
> > set verify off
> > set feedback on
> > set space 1
> > set serveroutput on size 1000000
> > set echo off
> >
> > set termout off
> > column d_bname new_value d_bname
> > select user ||'@'||instance_name d_bname
> > from v$instance ;
> > set sqlprompt '&d_bname.> '
> > set termout on
> > set pause on
> > /* **** end **** */
> >
> > Brian.
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: Brian_McQuillan_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).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Boivin, Patrice J
> > INET: BoivinP_at_mar.dfo-mpo.gc.ca
> >
> > 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Koivu, Lisa
> INET: lisa.koivu_at_efairfield.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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Grabowy, Chris
> INET: cgrabowy_at_fcg.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Koivu, Lisa
  INET: lisa.koivu_at_efairfield.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).