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: Keith Boulton <boulke_at_globalnet.co.uk>
Date: 1997/11/13
Message-ID: <346b16db.15315933@read.news.global.net.uk>#1/1

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 Received on Thu Nov 13 1997 - 00:00:00 CST

Original text of this message

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