Home » RDBMS Server » Server Administration » Hw to change utl_file_dir parameter
Hw to change utl_file_dir parameter [message #233420] Thu, 26 April 2007 01:50 Go to next message
kanis
Messages: 61
Registered: November 2006
Member
I need to change the value of utl_file_dir to '*'.
i am using oracle 9i. how i can do that?? do i need to log as sys ??
Re: Hw to change utl_file_dir parameter [message #233426 is a reply to message #233420] Thu, 26 April 2007 02:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ how to change?
- if you use spfile, just execute "alter system set utl_file_dir='...' scope=spfile
- if you use init.ora, change it in the file
Then restart the instance.

2/ should I change it to '*'
NO. It is a very bad idea.
Imagine someone writing in your database files!! Thumbs Down

Regards
Michel
Re: Hw to change utl_file_dir parameter [message #233427 is a reply to message #233420] Thu, 26 April 2007 02:21 Go to previous messageGo to next message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
You have to do it as a sysdba.

This ends up in the (s)pfile
Re: Hw to change utl_file_dir parameter [message #233444 is a reply to message #233427] Thu, 26 April 2007 02:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, any user with ALTER SYSTEM privilege can change the parameter setting.
To restart, of course, SYSDBA is required.


Regards
Michel

[edit: add missing word]

[Updated on: Thu, 26 April 2007 03:43]

Report message to a moderator

Re: Hw to change utl_file_dir parameter [message #233456 is a reply to message #233444] Thu, 26 April 2007 03:29 Go to previous messageGo to next message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
hahaha never thoughtv of that.

In my limited experience I never granted a user "alter session" privileges.

thanx for explaining.
Re: Hw to change utl_file_dir parameter [message #233530 is a reply to message #233420] Thu, 26 April 2007 08:17 Go to previous messageGo to next message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
If you are using 9i - forget about utl_file_dir.

Use CREATE DIRECTORY instead.

HTH.
Michael

Re: Hw to change utl_file_dir parameter [message #294520 is a reply to message #233530] Thu, 17 January 2008 22:07 Go to previous messageGo to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
If I want to add two specific directory in utl_file_dir parameter then can I do the following in init<sid>.ora file

utl_file_dir=/usr/tmp,/export/abc

or do I need to enclose with parenthesis
like

utl_file_dir=( /usr/tmp,/export/abc )

Thanks.


Re: Hw to change utl_file_dir parameter [message #294522 is a reply to message #233420] Thu, 17 January 2008 22:14 Go to previous messageGo to next message
BlackSwan
Messages: 25049
Registered: January 2009
Location: SoCal
Senior Member
shahnazurs ,
how sad after 190 post you still don't follow the posting guidelines.
Why can NOT you run your own simple test to see what works?
Why can not you Read The Fine Manual found at http://tahiti.oracle.com to read the answer yourself?
Why do you expect others to spoonfeed you turnkey solutions?
Why did you hijack a thread that was many months old & dormant rather than starting your own thread which included missing details like Oracle version?

So the answer to your question is, "YES".

[Updated on: Thu, 17 January 2008 22:15] by Moderator

Report message to a moderator

Re: Hw to change utl_file_dir parameter [message #294529 is a reply to message #294522] Thu, 17 January 2008 23:01 Go to previous message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Hi.

Thanks alot. I thought before posting this question let me search the same kind of topics in the forum. Since I got this thread so I just posted my query.
Sorry if I have done anything wrong.

Thanks.
Previous Topic: smtp server
Next Topic: Partioned index.(cannot extent segment size)
Goto Forum:
  


Current Time: Fri Dec 09 10:00:53 CST 2016

Total time taken to generate the page: 0.16831 seconds