Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Max # of datafiles??

Re: Max # of datafiles??

From: Nuno Souto <nsouto_at_acay.com.au>
Date: 1997/11/15
Message-ID: <346D7D00.3958@acay.com.au>#1/1

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

Works since V6.0.37. All V7.x and obviously, V8.

-- 
Nuno Souto
nsouto_at_NOSPAMacay.com.au
Received on Sat Nov 15 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US