Usually it's in <$ORACLE_HOME>/sqlplus/admin

It's a file called glogin.sql

We put stuff like this in ours:
SET numwidth 9
SET linesize 200
SET pagesize 66
SET define off
SET serveroutput ON
SET termout off
SET heading off
SET feedback off
spool set_prompt.sql
SELECT 'set sqlprompt "' || lower(user) || '\' || lower(name) ||'>"'
from v$database;
spool off
START set_prompt.sql
SET termout ON
SET heading ON
SET feedback ON


HTH

Larry

-----Original Message-----
From: Netz Randy N
[mailto:oracledba-ezmlmshield-x26070938.[Email address protected]
Sent: Thursday, December 30, 2004 12:21 PM
To: LazyDBA Discussion
Subject: Sqlplus Worksheet 9.0

I have a quick question. I use Sqlplus Worksheet a lot from me desktop.


Everytime I bring this GUI tool up, I have to set the pagesize and
linesize myself.

I know there is a parameter file that I can set these parameters in it
so that they are set when I bring the tool up ... but I cannot locate
it.

Does anyone know where it is, what it's called?



Randy Netz
Oracle DBA
816-860-3921 (work)
816-686-1639 (cell)




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page