Home » RDBMS Server » Server Administration » UTL_FILE error
UTL_FILE error [message #234371] Tue, 01 May 2007 04:32 Go to next message
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 #234418 is a reply to message #234371] Tue, 01 May 2007 09:42 Go to previous messageGo to next message
Michel Cadot
Messages: 65146
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you have such a line in your init.ora file, you don't need to create a Oracle directory object.
But you also have one of the biggest security issue you can have.
Imagine someone reading your datafiles. Hush! for the confidentiality.
Imagine someone writting on your datafiles. Hush! for your data and database.

Regards
Michel

Re: UTL_FILE error [message #234515 is a reply to message #234418] Tue, 01 May 2007 23:23 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 65146
Registered: March 2007
Location: Nanterre, France, http://...
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

Previous Topic: Unable to release space from table
Next Topic: sending mail
Goto Forum:
  


Current Time: Mon Aug 21 08:58:08 CDT 2017

Total time taken to generate the page: 0.10464 seconds