Path: news.cambrium.nl!textnews.cambrium.nl!feeder1.cambriumusenet.nl!feed.tweaknews.nl!209.197.12.246.MISMATCH!nx02.iad01.newshosting.com!newshosting.com!69.16.185.16.MISMATCH!npeer02.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!t13g2000yqt.googlegroups.com!not-for-mail
From: "Vladimir M. Zakharychev" <vladimir.zakharychev@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Oracle MAXDATAFILES
Date: Tue, 7 Jul 2009 06:09:43 -0700 (PDT)
Organization: http://groups.google.com
Lines: 25
Message-ID: <0011a482-3491-499d-be1d-503dfd68ae01@t13g2000yqt.googlegroups.com>
References: <db21cdfd-4898-443d-ac09-10f732b35d6c@a39g2000pre.googlegroups.com>
NNTP-Posting-Host: 91.196.34.22
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1246972183 22127 127.0.0.1 (7 Jul 2009 13:09:43 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 7 Jul 2009 13:09:43 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: t13g2000yqt.googlegroups.com; posting-host=91.196.34.22; 
 posting-account=PAnILQoAAAD84SMI2vqfU32t6U_KSuGX
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.1) 
 Gecko/20090624 Firefox/3.5 (.NET CLR 3.5.30729),gzip(gfe),gzip(gfe)
Xref:  news.cambrium.nl

On Jul 7, 11:46=C2=A0am, Ming=E4=BC=AF <l...@tech-trans.com> wrote:
> Hi,
>
> =C2=A0 How to determine MAXDATAFILES in a Oracle instance? =C2=A0At the s=
ame
> time, how to change MAXDATAFILES? =C2=A0Thx!
>
> 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=3D'DATAFILE'

Hth,
   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)
   http://www.dynamicpsp.com