DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: login.sql

  1. #1
    Join Date
    Nov 2000
    Posts
    440
    In oracle 8, i used to configure my login.sql for my sqlplus,
    but since i had oracle 8i, i dont have anymore login.sql.

    how can i configure my sql plus in 8i?

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    What do you mean you don't have login.sql? You mean it wasn't created during instalation? Are you looking in right directories?

    If it realy wasn't created during instalation you could simply create it manualy, just make sure you are putting it into right directory (or to put it in other words: make sure your environment variable SQLPATH points to that directory). In my instalation on NT the location of login.sql is in %ORACLE_HOME%\DBS, while glogin.sql is in %ORACLE_HOME%\SQLPLUS\ADMIN

    HTH,
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Oct 2000
    Posts
    467
    Hi,
    If u're using Oracle 8i client then u do have login.sql. If u're not using them then try out glogin.sql. you can set up some commands in here but frankly i've not used them.
    Do let me knwo if it is useful for u.

    Cheers,
    Vinit

  4. #4
    Join Date
    Apr 2000
    Location
    roma
    Posts
    131
    The "login.sql" file, may be placed in each (or only) directory that is your work directory...this is a similar "profile". Is useful if you have to put everytime.. linesize, pagesize, pause ..etc

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width