Re: 9i Newbie : spfile, sql-backtrack questions

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: 11 Apr 2002 22:38:57 -0700
Message-ID: <a95rth01bdv@drn.newsguy.com>

In article <3CB5F7C5.7991AD6B_at_mytoys.de>, Knut says...
>
>>Scope SPFILE writes only to the SPFILE, and only takes effect when you restart
>> the database. Only needed for the few remaining static parameters (like
>> UTL_FILE_DIR).
>
>BTW, does anybody know why UTL_FILE_DIR still is not system or session
>modifiable?
>
>Regards,
>
>Knut

Not sure but probably security reasons. At least by having it default to * (which is the default from memory) Oracle can write to any directory that the Oracle account can reach.

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Fri Apr 12 2002 - 00:38:57 CDT