Re: Max # of datafiles??

You can do this by recreating the control files.

At the server maanager prompt enter:

    alter database database_name

        backup controlfile to trace;

You will find a trace file in your UDUMP directory. This will contain the command to recreate the controlfile.
Modify the MAXDATAFILES parameter and run the script.

Roy Klassen rklassen_at_pei.sympatico.ca

MC12250 <mc12250_at_aol.com> wrote in article <19971112222700.RAA21721_at_ladder02.news.aol.com>...
> I have a production DB that was created with a max of 30 datafiles in
 the
> "CREATE DATABASE" statement. I know the parameter in the init.ora file
> can't override this. Is there an easy way to change this without
 re-creating
> the
> DB?
>
> Thanks,
> andy
> andy_at_mcdirect.com
>
>
>
Received on Thu Nov 13 1997 - 00:00:00 CST