OraFAQ Forum: Server Administration » How to execute .sql file on oracle server startup.

Home » RDBMS Server » Server Administration » How to execute .sql file on oracle server startup.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to execute .sql file on oracle server startup. [message #168971]

Mon, 24 April 2006 07:56

sreek_s
Messages: 45
Registered: May 2005
Location: Andaman Nikobar

Member

Hi,
I want to execute a .sql file whenever oracle server starts.
Which directory i have to put my .sql file?
And where to specify.

Please help me out.

Regds,
Sree

Report message to a moderator

Re: How to execute .sql file on oracle server startup. [message #168973 is a reply to message #168971]

Mon, 24 April 2006 08:09

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Not sure what you are exactly looking into?
You want to execute something everytime the server starts or everytime you login with sql*plus?
for the later option, edit your glogin.sql in $ORACLE_HOME/sqlplus/admin.
For the first option, there is no 'default' directory.
workarounds are
1. a startup trigger, built within the database that will do whatever need.
2. In unix, you typically use a dbstart /dbshut script available in $ORACLE_HOME/bin. You can make appropriate entries.
3. In windows, you can write your own startup/shutdown script.

Report message to a moderator

Re: How to execute .sql file on oracle server startup. [message #169070 is a reply to message #168973]

Mon, 24 April 2006 23:52

sreek_s
Messages: 45
Registered: May 2005
Location: Andaman Nikobar

Member

Hi,
I wrote a startup trigger , but it is not getting fired.
I logged in as system/manager and executed the trigger.
what could be the problem?

Regds,
Sri

[Updated on: Mon, 24 April 2006 23:53]

Report message to a moderator

Re: How to execute .sql file on oracle server startup. [message #169106 is a reply to message #169070]

Tue, 25 April 2006 02:09

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>what could be the problem?
YOu have to help us to find that.
No information on Version,errors,source code. With the wealth of information provided we cannot proceed

[Updated on: Tue, 25 April 2006 07:52]

Report message to a moderator

Previous Topic:	Regarding V$session_longops
Next Topic:	SCENARIOS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 14:37:24 CDT 2024