| UTL_FILE error [message #234371] |
Tue, 01 May 2007 04:32  |
shahnazurs
Messages: 240
Registered: June 2005
Location: India
|
Senior Member |
|
|
Hi,
oracle 9i release 1 and SunOS 5.8 are the configuration of my system.
utl_file_dir='*' is the entry in init<sid>.ora file
do we need to create directory like
create directory xyz as '/usr4/home';
do we need to create directory explicitly?
Thanks.
|
|
|
|
|
|
| Re: UTL_FILE error [message #234515 is a reply to message #234418] |
Tue, 01 May 2007 23:23  |
shahnazurs
Messages: 240
Registered: June 2005
Location: India
|
Senior Member |
|
|
Thanks Michel.
Yeah i too agree what you say!!! My doubt again is in oracle 9i release 1, we don't want to fire "create directory" commnad? am i right?
Thanks.
|
|
|
|
| Re: UTL_FILE error [message #234516 is a reply to message #234515] |
Tue, 01 May 2007 23:43 |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
I don't remember if you can use Oracle directory in 9.0 utl_file (I think so) but this is in the documentation which is online.
If you can use Oracle directory, you should do.
It is dynamic (you don't have to restart the instance if you want to change or add one).
It is safe (you can choose to give read or write or read and write access). You can control access rights at user level (not instance one).
Regards
Michel
[Updated on: Tue, 01 May 2007 23:43] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
