Re: maxdatafiles -- inquiry/update

esc_at_netcom.com (Steve Etchelecu) writes:

>
> I am looking for a method to inquire on the current value for
> the MAXDATAFILES parameter which was set when a database is created.
>
> More importantly, I am looking for a method to increase this value
> without having to recreate the database.
>

The only way to set the MAXDATAFILES value is to do a CREATE DATABASE. To change it, you have to export the old DB and re-create. The dc_files parameter in init.ora is kind of cosmetic. It can't override maxdatafiles. Check the create_host_instance.sql script in the ora_instance directory; it's created by the installation procedure. If there's no maxdatafile spec, then you're stuck with the default, which is 32 in VMS. When you recreate the DB, set maxdatafiles high; the control file size will then increase nominally.

The only other way I can think of to view maxdatafiles size would be to do a trace dump of the control file; any oracle.com folks care to contribute the syntax? It's something like "alter database trace immediate controlf level 3" ???

kml.

               Personally, I skip the posts and just read the sigs.

  kml%cellar_at_tredysvr.tredydev.unisys.com - My other account is a Mercedes. Received on Fri Aug 28 1992 - 14:32:02 CEST