Something similar to .profile on Unix

[Umesh_Shar]

Hi,
When I type sqlplus from the unix prompt and get into the sql prompt. I want certain things to be set initially. Like for Ex : set timing on, set head off,etc. Just like what a .profile does when you log into your account in a Unix box. Is there any way to do this in Oracle.


Thanks,
Umesh

[ales]

Hi,

$ORACLE_HOME/sqlplus/admin/glogin.sql

is the file you can put your settings in.

Regards,
Ales

[Umesh_Shar]

What if I am a normal user and not an admin?

[ales]

Then login.sql in your local directory.

[Umesh_Shar]

Thanks ales