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!

UTL_FILE_DIR param ORA-02095:specified init parameter cannot be modified

582145May 6 2008 — edited May 6 2008
Hi,

Release 10.2.0.3.0, RH Linux

SELECT value FROM v$parameter WHERE name='utl_file_dir';
returns VALUE = NULL

ALTER SYSTEM SET utl_file_dir='/home/myuser/bill_reports/archived_rpts','/home/myuser/bill_reports/csv_files' SCOPE=both errors out

Error report:
SQL Error: ORA-02095: specified initialization parameter cannot be modified
02095. 00000 - "specified initialization parameter cannot be modified"
*Cause: The specified initialization parameter is not modifiable


So, how do I go about setting the UTL_FILE_DIR value to my dirs?

Thanks,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 3 2008
Added on May 6 2008
#general-database-discussions
1 comment
3,965 views