Re: confused about glogin.sql

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Fri, 23 Jul 1999 00:55:07 GMT
Message-ID: <37a3b9c3.2380973@netnews.worldnet.att.net>

On Thu, 22 Jul 1999 17:02:48 +0530, Anurag Minocha <anurag_at_synergy-infotech.com> wrote:

>Will the glogin.sql script execute when i start the database or will it
>only exceute when i bring up sqlplus.

glogin.sql is a SQL*Plus login script. It's read and executed by SQL*Plus, not the database. If you are executing SQL*Plus from different client machines, each of those machines could have its own glogin.sql file.

To my knowledge, there is no way to have Oracle automatically execute a script on startup. You would have to write a startup shell script, and execute that instead of using the Server Manager startup command.

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are Received on Thu Jul 22 1999 - 19:55:07 CDT