Re: Database creation parameters

From: Jeremy Russell <jeremy.russell.deletethisbit._at_usa.net>
Date: Wed, 16 Dec 1998 12:58:26 GMT
Message-ID: <3677ae02.35110104@news.earthlink.net>

James, try using this SQL statement:

ALTER DATABASE BACKUP CONTROLFILE TO TRACE; then check the trace file (in your DB's user_dump_dest directory) - that trace file will contain statements that re-create the control files for you, and includes the MAXxxxx options.

Hope that helps.
JR

"James McKay" <mckayja_at_logica.com> wrote:

>Yes, but where are they stored? I'm trying to reverse-engineer a database
>creation script. As this information is held in the database, I should be
>able to SELECT it.
>
>MotoX <noone_at_nowhere.com> wrote in article
><3677c6d1.1222268_at_news.demon.co.uk>...
>: In the control files.
>:
>: MotoX.
>:
>: On 15 Dec 1998 17:00:51 GMT, "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 Wed Dec 16 1998 - 06:58:26 CST