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
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