Skip to Main Content

Infrastructure Software

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 value not registered

56679Oct 26 2001
Hello,

Using Oracle 9.0.1 on SuSe Linux 7.2 Kernel 2.4.6.
We have set:

UTL_FILE_DIR = /opt/oracle/product/9.0.1/output_files

in INIT.ORA. After restarting the server, UTL_FILE_DIR is
registered but empty:

----------
select * from v$parameter where name='utl_file_dir'
1 row(s) selected

NUM 443
NAME utl_file_dir
TYPE 2
VALUE
ISDEFAULT TRUE
ISSES_MODIFIABLE FALSE
ISSYS_MODIFIABLE FALSE
ISMODIFIED FALSE
ISADJUSTED FALSE
DESCRIPTION utl_file accessible directories list
UPDATE_COMMENT

1 row(s) retrieved
----------

Has anyone an idea what is going wrong? Thanks for your helpful
suggestions.

Regards,
Hans.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 26 2001
Added on Oct 26 2001
3 comments
337 views