OraFAQ Forum: SQL & PL/SQL » how to set the UTL_FILE directory intialization in INIT.ORA in windows

Home » SQL & PL/SQL » SQL & PL/SQL » how to set the UTL_FILE directory intialization in INIT.ORA in windows

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

how to set the UTL_FILE directory intialization in INIT.ORA in windows [message #225164]

Sun, 18 March 2007 13:43

deshikiran
Messages: 3
Registered: March 2007
Location: hyderabad

Junior Member

hi
please help me out regarding metion matter.

Report message to a moderator

Re: how to set the UTL_FILE directory intialization in INIT.ORA in windows [message #225165 is a reply to message #225164]

Sun, 18 March 2007 13:52

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>how to set the UTL_FILE directory intialization in INIT.ORA in windows
Not sure what this has to do with PL/SQL.
Not sure why this is requires an EXPERT to answer.
The solution is to make sure no spfile exists & use editor of choice to add appropriate parameter to initSID.ora file & restart DB.

http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams006.htm#i1124822

Report message to a moderator

Re: how to set the UTL_FILE directory intialization in INIT.ORA in windows [message #225168 is a reply to message #225164]

Sun, 18 March 2007 14:22

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

If you are using 9i or above, you may want to use CREATE DIRECTORY instead of UTL_FILE_DIR parameter in initsid.ora
http://download-east.oracle.com/docs/cd/B10501_01/appdev.920/a96612/u_file.htm#998101

Report message to a moderator

Previous Topic:	create new table from existing tables with no rows
Next Topic:	hi guys help me out for these problem on procedures

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 20 07:00:22 CDT 2025