OraFAQ Forum: Server Administration » Hw to change utl_file

Home » RDBMS Server » Server Administration » Hw to change utl_file_dir parameter

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Hw to change utl_file_dir parameter [message #233420]

Thu, 26 April 2007 01:50

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 ??

Report message to a moderator

Re: Hw to change utl_file_dir parameter [message #233426 is a reply to message #233420]

Thu, 26 April 2007 02:20

Michel Cadot
Messages: 68683
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

Report message to a moderator

Re: Hw to change utl_file_dir parameter [message #233427 is a reply to message #233420]

Thu, 26 April 2007 02:21

martijn
Messages: 286
Registered: December 2006
Location: Netherlands

Senior Member

You have to do it as a sysdba.

This ends up in the (s)pfile

Report message to a moderator

Re: Hw to change utl_file_dir parameter [message #233444 is a reply to message #233427]

Thu, 26 April 2007 02:56

Michel Cadot
Messages: 68683
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

martijn
Messages: 286
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.

Report message to a moderator

Re: Hw to change utl_file_dir parameter [message #233530 is a reply to message #233420]

Thu, 26 April 2007 08:17

michael_bialik
Messages: 621
Registered: July 2006

Senior Member

If you are using 9i - forget about utl_file_dir.

Use CREATE DIRECTORY instead.

HTH.
Michael

Report message to a moderator

Re: Hw to change utl_file_dir parameter [message #294520 is a reply to message #233530]

Thu, 17 January 2008 22:07

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.

Report message to a moderator

Re: Hw to change utl_file_dir parameter [message #294522 is a reply to message #233420]

Thu, 17 January 2008 22:14

BlackSwan
Messages: 26766
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

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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 16 05:46:38 CDT 2024