oracle utl_file_dir

key words: invalid file operation,utl_file_dir

how to set utl_file_dir in oracle?

my db is Oracle10g,and the default boot method is spfile

1. sql> alter system set utl_file_dir=’c:\tmp’ scope=spfile

2.sql>shutdown immediate

3.sql>start

This time I change the mydbspfile.ora directly,but made mistake,late resolved it by

“create spfile from pfile”

reference here