Re: SQL*Plus Saving Environment?

From: Marc Weinsock <MWeinstock_at_lds.com>
Date: Thu, 13 Jan 2000 15:55:59 GMT
Message-ID: <387DF5D3.E4B373BE@lds.com>

Like the other threads were saying, U can create a login.sql(NT) or glogin.sql(unix) (there might be some more flavors of login.sql) and call the sql script from there.

IN NT, there is a DOS environment variable that U can place into your autoexec.bat file that will tell sqlplus where to look for sqlfiles that do not have a path. SQLPATH=e:\myoradata;e:\orant\dbs;c:\orant\bin;

1.Place the following in your autoexec.bat and reboot.

SQLPATH=e:\myoradata;e:\orant\dbs;c:\orant\bin; 2. IN SQLPLUS: store e:\myoradata\mydefaults.sql 3. Create a login.sql in any of these folders with the following entry @e:\myoradata\mydefaults.sql

or (this should be simpler.)

1. open sqlplus
2. change the defaults to what U like.
3. store login.sql
4. close sqlplus and open sqlplus to test.

Georg Schulte Althoff wrote:

> Thank you for this documentation. This is very good to save the whole
> setting.
> The only thing I'm still missing is how to execute the resulting file
> automatically
> at every start of SQL*Plus.
>
> Is there nothing like a "autoexec" at the start of SQL*Plus?
>
> Georg

Marc Weinstock
Logical design Solutions

55 Broadway - 21st Floor
New York, New York 10006

Phone: 800.221.5327 x2136
Fax: 212-825-2245
E-Mail: MWeinstock_at_lds.com
Web: http://www.lds.com Received on Thu Jan 13 2000 - 09:55:59 CST