Re: utl_file_dir setting not working

From: Donald Candy <dcandy_at_home.com>
Date: Tue, 18 Jan 2000 06:01:01 GMT
Message-ID: <388401BB.AC78659@home.com>

How do you know it's not working? What tool are you using? If SQL*PLUS, make sure you are using "set serveroutput on". Try putting a "*" at the end of the parameter in the init?.ora, possibly the directory specification is invalid. Make sure you connect before issuing the "set" command. Some ideas to try.......

real wrote:

> For some odd reason, the setting up of utl_file_dir is not working on
> our Oracle 8.0.5 Database -- Solaris 2.7.
>
> Here's what I have done:
>
> Setting in init<SID>.ora specifying directory
> Bounced instance.
> Recompiled sys schema (as a last ditch effort).
>
> I've checked the all_directories view, there is nothing there.
> I've checked in the sys.dir$ table (base table view queries) and nothing
> is there -- expected.
>
> We have this working on other servers, so I don't get what the problem
> is.
>
> Any ideas?
>
> Thanks in advance.
Received on Tue Jan 18 2000 - 00:01:01 CST