Re: utl_file_dir showing up empty

From: Kyle Pinches <klpinches_at_sep.com>
Date: 28 Aug 2002 06:32:33 -0700
Message-ID: <31716f18.0208280532.6ba2182d@posting.google.com>

Thanks Rauf! That looks like it was the problem... The parameter shows up properly now!

Guess it's time for me to read a bit more... I'm still fairly new to using Oracle and have been focused primarily on the development side of things up until now.

~Kyle

rs_arwar_at_hotmail.com (Rauf Sarwar) wrote in message news:<92eeeff0.0208272106.41612e94_at_posting.google.com>...
>
> Your problem may be related to SPFILE being out of sync from your
> PFILE. In 9i, when database is started up by just using "SQL> startup"
> command, Oracle uses SPFILE parameters. Read more about new SPFILE
> feature in your 9i docs and how to sync your SPFILE and PFILE. In the
> meantime, try to force Oracle to startup by exclusively using your
> pfile parameters like,
>
> SQL> startup pfile=<Full path and name to pfile>
>
> //Rauf Sarwar
Received on Wed Aug 28 2002 - 08:32:33 CDT