Auto run sql script when DB opens

651550

Is it possible to configure a DB so a given SQL script is run each time the database opens?

Thanks a lot in advance.

595286

You can create an after startup trigger to run PL/SQL

Is it ok for you or do you really need to call a script stored on disk ?

http://download.oracle.com/docs/cd/B28359_01/server.111/b28318/triggers.htm#i6061

595286

You can create an after startup trigger to run PL/SQL

Is it ok for you or do you really need to call a script stored on disk ?

http://download.oracle.com/docs/cd/B28359_01/server.111/b28318/triggers.htm#i6061

347756

The trigger on system startup is a way of doing this. If you use the dbstartup and dbshutdown scripts, you could add a line in the script to execute your startup script.

Niall Litchfield

rafadc wrote:
Is it possible to configure a DB so a given SQL script is run each time the database opens?

Thanks a lot in advance.

Either include the script in a startup script for the database, dbstart on *nix you'd need to write your own on windows, or else move the code into a startup trigger.

Niall Litchfield
http://www.orawin.info/