Re: Oracle MAXDATAFILES
Date: Tue, 7 Jul 2009 06:09:43 -0700 (PDT)
On Jul 7, 11:46 am, Ming伯 <l..._at_tech-trans.com> wrote:
> How to determine MAXDATAFILES in a Oracle instance? At the same
> time, how to change MAXDATAFILES? Thx!
Oracle version? All releases since 8i automatically expand control file when MAXDATAFILES is exceeded as long as the number of files does not exceed DB_FILES initialization parameter, but for 8i MAXDATAFILES was a hard limit and you had to recreate the control file to change it. Note that DB_FILES still limits the number of data files, but this one can easily be changed. To find out current MAXDATAFILES, you can use this query:
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Tue Jul 07 2009 - 08:09:43 CDT