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