Re: Oracle init.ora file - init_sql_files

• wrote:

> We run on Oracle 7.2.
>
> The initialization parameter init_sql_files has been commented out
> on our init<dbname>.ora file.
>
> What are the consequences of this when the database is started up
> each time?
>
> Thank you in advance.
>
> Ardiel Soodyall
> Newbie DBA
> Technikon Natal

That parameter lists which scripts should be executed during a database creation. Unless there are some specific scripts that need to be run at creation time and you don't want to run them manually (that's assuming you would even be using the same INIT.ORA), you are really not impacting anything. That parameter is pretty much a one-shot use.

--
====================================================================
Byron Pearce                         mailto:bpearce_at_csac.com
Systems Consultant                   http://www.csac.com
Computer Systems Authority (CSA)     Dallas, Texas

"It's hard to be a ninja when you wear a beeper."