Re: Q: Is there a way to change MAXDATAFILES after Instance createion ?

From: Kevin Jernigan <kjerniga_at_emergent.com>
Date: 1996/02/12
Message-ID: <kjerniga-1202961423530001_at_slipkevinj.emergent.com>#1/1


Look in the SQL Language Reference Manual, under CREATE CONTROLFILE. This should point you in the right direction.

   -Kevin J

In article <4ff2nr$53v_at_ubnsrv.unisource.ch>, mpammer_at_vlr.gv.at (Martin Pammer) wrote:

> Hi there
>
> We are using Oracle 7.2.2.4 on AIX 4.1.3.
>
> I have several databases which were all created with the default
> MAXDATAFILES of 20.
>
> After creating new tablespaces I am now coming close to the limit
> of 20 datafiles.
>
> My question is:
>
> Can I change the MAXDATAFILE after instance creation without
> recreation of the whole database ?
>
> Thank You very much in advance
>
> Martin Pammer
> mpammer_at_vlr.gv.at (VRZ Informatik in Dornbirn, Austria)
 

-- 
~~~~~~~~~~~~ emergent: delivering scalable solutions ~~~~~~~~~~~~~~~
kevin jernigan                                      415-567-8915 (p)
emergent corporation                                415-265-0785 (c)
kjerniga_at_emergent.com   http://www.emergent.com     415-367-6414 (f)
Received on Mon Feb 12 1996 - 00:00:00 CET

Original text of this message