| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> NEVER MIND - WAS - RE: SQL Plus Environment
I fixed it. I decided if the DBS directory was not created by the Oracle install than I will go and create the directory for Oracle. I then dropped my login.sql into the directory, fired up SQLPlus and my login.sql worked. Maybe I should of just sent a HELP instead. ;o)
Dave
-----Original Message-----
Sent: Tuesday, February 11, 2003 12:22 PM
To: Multiple recipients of list ORACLE-L
I want to set up a glogin.sql and a login.sql. I am reading the manual and I find this. Oh yea. I'm on 8.1.7 on NT.
When you install SQL*Plus, LOGIN.SQL is copied to the DBS subdirectory, and GLOGIN.SQL is copied to the SQLPLUS\ADMIN subdirectory of your Oracle home directory. If you modify LOGIN.SQL or GLOGIN.SQL, make sure you do not add any ANSI escape sequences. See "Setting Up Your SQL*Plus Environment" in Chapter 3 of the SQL*Plus User's Guide and Reference <../../server.817/a82950/toc.htm>, which describes the LOGIN.SQL and GLOGIN.SQL files.
I can find the glogin.sql on my client PC and have edited it to my liking. But I cannot find the login.sql and I do not have the DBS directory. I see a DBS directory on the server but not on the client. Am I missing something or does login.sql not exist on 8.1.7.
Thanks,
Dave
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Farnsworth, Dave
INET: DFarnsworth_at_Ashleyfurniture.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: 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.net
--
Author: Farnsworth, Dave
INET: DFarnsworth_at_Ashleyfurniture.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: 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). Received on Tue Feb 11 2003 - 12:39:53 CST
 |
 |