Cool, you learn something new everyday.
Dan
-Original Message-
Sent: Wednesday, March 14, 2001 8:05 PM
To: Multiple recipients of list ORACLE-L
Dan -
I've previously used the * to define utl_file_dir with no problems.
According to the documentation:
"The parameter specification
utl_file_dir = * is VERY bad news...
for i in (
select file_name
from dba_data_files ) loop
open file i.file_name for write
end loop;
and voila...No more db
--- "Dasko, Dan" [EMAIL PROTECTED] wrote:
Cool, you learn something new everyday.
Dan
-Original Message-
Sent:
Connor -
Fortunately, that requires dba privs which (see previous posts from
Rachael, Lisa, et al) your folks don't have. Right?
Actually though, you make a good point - there is some risk involved in
setting the parameter to *. The files are created/written as the oracle
user, so any
I thought that a directory had to be specified by name in initora. I don't
think you can specify a wildcard or a higher level directory. I could be
wrong.
Dan
-Original Message-
Sent: Wednesday, March 14, 2001 5:16 AM
To: Multiple recipients of list ORACLE-L
List hi!
Oracle817 on
Hi,
Eventhough you have given the path as * in initora
Make sure that the path where you are creating the file
is access to the Unix User , who is running the script
The unix user should have the access Read , Write and Execute
But the User thur which Oracle is Installed will be able to run
You're supposed to set the parameter to a directoryname,
not an asterisk. Setting the parameter to something like
/oracle/base/8.1.7/work
and setting the protection of the directory to 0644 (files are
written by the oracle server processes) should help.
-Original Message-
Of course, with 8.1.7 you can implement your own UTL_FILE package,
using external calls to C routines.
-Original Message-
Sent: Wednesday, March 14, 2001 5:16 AM
To: Multiple recipients of list ORACLE-L
List hi!
Oracle817 on AIX. (64 bit)
We have defined in initora file UTL_FILE_DIR=*
, 2001 10:07 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: problem with UTL_FILE.FILE OPEN
I thought that a directory had to be specified by name in
initora. I don't
think you can specify a wildcard or a higher level directory.
I could be
wrong.
Dan
-Original Message
of list ORACLE-L
Subject: RE: problem with UTL_FILE.FILE OPEN
You're supposed to set the parameter to a directoryname,
not an asterisk. Setting the parameter to something like
/oracle/base/8.1.7/work
and setting the protection of the directory to 0644 (files are
written
To: Multiple recipients of list ORACLE-L
Subject: RE: problem with UTL_FILE.FILE OPEN
I thought that a directory had to be specified by name in
initora. I don't
think you can specify a wildcard or a higher level directory.
I could be
wrong.
Dan
-Original Message-
Sent
Dan -
I've previously used the * to define utl_file_dir with no problems.
According to the documentation:
"The parameter specification UTL_FILE_DIR = * has a special meaning.
This entry turns off directory access checking, and it makes any
directory accessible to the UTL_FILE functions."
I'm
11 matches
Mail list logo