Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Max # of datafiles??
At least; as of at 7.1.6.2 you can re-create the control file. See Metalink for a paper on re-creating the control file to up your MAXDATAFILES.....
If you don't have the correct answers DON'T post.
> Keith Boulton wrote:
>
> > On 12 Nov 1997 22:27:16 GMT, mc12250_at_aol.com (MC12250) wrote:
> >
> > > 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
> > >
> > >
> >
> > In version 8 ( I'm not sure about 7), use the CREATE CONTROLFILE
> > command - see the sql reference
>
> In version 7 you will need to recreate the database.
Received on Fri Nov 14 1997 - 00:00:00 CST