Home -> Usenet -> comp.databases.oracle -> Q: Is there a way to change MAXDATAFILES after Instance createion ?

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

From: Martin Pammer <mpammer_at_vlr.gv.at>
Date: 1996/02/09
Message-ID: <4ff2nr$53v_at_ubnsrv.unisource.ch>#1/1 






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)
Received on Fri Feb 09 1996 - 00:00:00 CET












Original text of this message