一, 读写目录要先建好, 保证对这个目录有读写权限.
二, 正确设置UTL_FILE_DIR.
我的错误是设置参数的方法不对, 其实根本没设置上.
[alter system set UTL_FILE_DIR = '/opt/oracle/tmp' scope = spfile;
]实现了对参数的设定.运行的结果是在.../dbs/spfilexs.ora的文件中追加了[*.utl_file_dir='/opt/oracle/tmp']
如下结果.
*******************************************************
SQL> alter system set utl_file_dir = '/opt/oracle/tmp' scope = spfile;
System altered.
SQL> show parameter utl;
NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
utl_file_dir string
/opt/oracle/tmp
*******************************************************
二, 正确设置UTL_FILE_DIR.
我的错误是设置参数的方法不对, 其实根本没设置上.
[alter system set UTL_FILE_DIR = '/opt/oracle/tmp' scope = spfile;
]实现了对参数的设定.运行的结果是在.../dbs/spfilexs.ora的文件中追加了[*.utl_file_dir='/opt/oracle/tmp']
如下结果.
*******************************************************
SQL> alter system set utl_file_dir = '/opt/oracle/tmp' scope = spfile;
System altered.
SQL> show parameter utl;
NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
utl_file_dir string
/opt/oracle/tmp
*******************************************************