Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

setting utl_file_dir

user7202581Mar 13 2013 — edited Mar 14 2013
Hi,

I need to set the value for utl_file_dir and we are using spfile in the DB.
Is a bounce of the DB required to set this value?

I used this command alter system set utl_file_dir='/opt/oracle/product/10.2.0/cds/interface' scope=spfile;

System altered.
But still the value shows as null.

SQL> show parameter utl_file_dir

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
utl_file_dir string

Please advise.

Regards,
Narayan
This post has been answered by JustinCave on Mar 13 2013
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 11 2013
Added on Mar 13 2013
#general-database-discussions
9 comments
15,865 views