From: Vladimir M. Zakharychev <>
Date: Tue, 7 Jul 2009 06:09:43 -0700 (PDT)
Message-ID: <>

On Jul 7, 11:46 am, Ming伯 <> wrote:
> Hi,
>   How to determine MAXDATAFILES in a Oracle instance?  At the same
> time, how to change MAXDATAFILES?  Thx!
> Ming

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:

select records_total
  from v$controlfile_record_section
 where type='DATAFILE'


   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm) Received on Tue Jul 07 2009 - 08:09:43 CDT

Original text of this message