Re: use of SPFILES, UTL_FILE_DIR and Create directory...

From: HansF <News.Hans_at_telus.net>
Date: Sat, 26 Mar 2005 12:44:33 GMT
Message-Id: <pan.2005.03.26.13.46.03.983683@telus.net>

On Sat, 26 Mar 2005 12:57:38 -0800, Verner Jensen, Ålborg wrote:

> Hi'
>
> Could anyone pls explain
> - what an SPFILE is?

It's the new parameter file, replaces the [still available] init.ora, but contains binary data. It is updated by the server so that you can ALTER stuff at the system level at run time and those changes can survive db shutdowns if you want. It should never be edited manually.

> - Why its possible from 9i - to use "create directory" instead of
> UTL_FILE_DIR
Because Oracle set it up that way.

Read up in the Concepts Manual and Administrator's Guide. Ditto for question 1 - you want to know how to convert back and forth between pfile and spfile

/Hans
BTW: cross posting to the comp.databases.oracle heirarchy not necessary Received on Sat Mar 26 2005 - 06:44:33 CST