Re: OEM - 9i Windows XP -

"Jeremy" <newspostings_at_hazelweb.co.uk> wrote in message news:MPG.1b3cc61e67bb8115989c6e_at_news.individual.net...
> In article <40d1ed8f$0$6203$afc38c87_at_news.optusnet.com.au>, Howard J.
> Rogers says...
> > But reading your post again, I don't think you want to add a new
parameter
> > at all. You just want to add a new value to an existing parameter
> > (UTL_FILE_DIR takes a comma-separated list of values as its argument,
rather
> > in the same way as CONTROL_FILES does).
> >
>
> I already had a setting
> c:\utlfiledir
>
> which was working fine.
>
> Then I changed this to
> c:\utlfiledir, c:\utlfiledir\admin
>
> and I wasn't able to write into the latter of the 2 directories.

Ah. Well, it always pays to read the documentation, doesn't it:

"If you are specifying multiple directories, you must repeat the UTL_FILE_DIR parameter for each directory on separate lines of the initialization parameter file." (from tahiti.oracle.com).

So ignore that rubbish I wrote earlier. :-( Sorry.

In which case, we are back to square one regarding your initial problem, and I can only think this is one of those times when you'll have to get your hands dirty with a command line edit of your init.ora.

I believe that you're encourage to be creating directory objects and such like these days instead of using utl_file_dir, so maybe that's why the functionality is a bit lacking.

Regards
HJR Received on Fri Jun 18 2004 - 05:20:10 CDT