Re: change maxdatafile

From: Piotr Kolodziej <pkol_at_otago.gda.pl>
Date: Thu, 3 Dec 1998 16:11:58 +0100
Message-ID: <7469up$9p3$1@sunrise.pg.gda.pl>

Michael James Seymour wrote in message = <7464vj$avo$1_at_coranto.ucs.mun.ca>...
>This is probably a simple solution but I can't figure it out at all. =
How
>can I change the MAXDATAFILE value? I'm running Oracle 7.3.3.0.0 on
>DEC UNIX 4.0D. I never set it during the database creation and the
>default is 30, I need more. Any way to change this?
>
>Thanks.

If your db_files parameter in init.ora already reached the database (in fact control file entries) limit, you need to recreate control file with proper maxdatafiles parameter.
Using 'alter database backup controlfile to trace' gives a trace file near ready to use as a script.

HTH,
Piotr
--
Piotr Kolodziej pkol_at_otago.gda.pl Received on Thu Dec 03 1998 - 09:11:58 CST