From: Dick Allie <dallie@ionet.net>
Subject: Re: max db_files on 7.2.3
Date: 1997/05/05
Message-ID: <336DE166.212A@ionet.net>#1/1
References: <01bc4ec8$4c0a4b20$0349030a@Singnet.singnet.com.sg> <19970504171300.NAA17898@ladder01.news.aol.com>
To: MarkP28665 <markp28665@aol.com>
Organization: Macklanburg-Duncan
Reply-To: dallie@ionet.net
Newsgroups: comp.databases.oracle.server




MarkP28665 wrote:
> 
> Baan Canada <Rob_Van_Brandenburg@baan.com> wrote in article
> <01bc405e$8b58fe20$e9edb6ce@robvb.BAANAM>...
> > Running Oracle 7.2.3.
> > Can't create more than 30 datafiles !
> > db_files = 100
> >
> > Suggestions ?
> >
> > Rob.
> >
> Reply was >> Check maxdatafiles
> 
> If this in on a Unix system check the OS Oracle user resource limits,
> i.e., ulimit.
> 
> 
> Mark Powell  -- The only advise that counts is the advise that you follow
> so follow your own advise

When database was created maxdatafiles was set to 30 or the default
was used.  You can reset the maxdatafiles by recreating the control
files.  prior to a full backup enter a sql command
alter database backup control file to trace;
this will create a trace file in the user trace files location.
You can edit this trace file to change the maxdatafiles to a larger
value.  Save the old control files. startup the database in mount mode.
run the edited trace file in svrmgr or sqldba. then alter the database
open.

If you need more detail email me.  Dick Allie - dallie@ionet.net