How to insert a value into 'utl_file_dir'_ 1

[marrow]

show parameter utl" displays null value
NAME TYPE VALUE
------------------------------------ ----------- ---------
utl_file_dir string

I have specified the directory FLATFILE in spfilexxx.
Isn't spfile dynamic? I also restarted database

*.utl_file_dir='/directorya/FLATFILE'

How can I add the directory value?

 

[LKBrwnDBA]

UTL_FILE_DIR is not a dynamic parameter, you need to change it in the pfile (initXXX.ora) and re-start database:

In SQL*Plus do:

create pfile from spfile;
shutdown immediate;
-- Change/Add UTL_FILE_DIR
startup pfile=$ORACLE_HOME/dbs/initXXX.ora
create spfile from pfile.




----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[marrow]

Thanks LKBrwnDDBA,

I thought that the spfilexxxx.ora replaced init.ora so do I need to touch init.ora?

 

[LKBrwnDBA]

Yes, spfile replaced init.ora, except when you need to change non-dynamic parameters, you need to follow the instructions I posted.


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[marrow]

I will let you know LKBrwnDDBA, thanks again.

 

[marrow]

Thanks for your help LKBrwnDDBA, all working OK.