Re: Database creation parameters

From: Jeremy Russell <jeremy.russell.deletethisbit._at_usa.net>
Date: Fri, 18 Dec 1998 11:36:30 GMT
Message-ID: <367a3dec.3792332@news.earthlink.net>

In the control files. Try running

"ALTER DATABASE BACKUP CONTROLFILE TO TRACE" and examine the newly created trace file in your BACKGROUND_DUMP_DEST directory. It'll contain SQL statements to recreate the control file, and will include the parameters you mention.

Hope that helps

"James McKay" <mckayja_at_logica.com> wrote:

>Hi,
> Can anyone tell me where exactly Oracle stores database creation
>parameters, such as MAXLOGFILES, MAXDATAFILES etc? Thanks in advance.
>James.
Received on Fri Dec 18 1998 - 05:36:30 CST