Home » SQL & PL/SQL » SQL & PL/SQL » how to set the UTL_FILE directory intialization in INIT.ORA in windows
how to set the UTL_FILE directory intialization in INIT.ORA in windows [message #225164] Sun, 18 March 2007 13:43 Go to next message
deshikiran
Messages: 3
Registered: March 2007
Location: hyderabad
Junior Member
hi
please help me out regarding metion matter.
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 Go to previous messageGo to next message
BlackSwan
Messages: 25033
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
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 Go to previous message
Mahesh Rajendran
Messages: 10672
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
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:
  


Current Time: Fri Dec 02 23:15:39 CST 2016

Total time taken to generate the page: 0.13570 seconds