Re: Altering max datafiles set on installation?

No, don't do that. Just recreate your controlfiles with a higher maxdatafiles setting. This is in the manuals and has been discussed here numerous times. Briefly, to get you started: :

1. In svrmgr: alter database backup controlfile to trace;
2. shutdown
3. edit the trace file created in step 1, increase maxdatafiles, save it.
4. startup nomount
5. @trcfile

M.Landa

Joey Brouillette wrote:

> Sorry, but my understanding is that you have to rebuild the database.
> (You
> do not have to reinstall Oracle to accomplish this.)
>
> Claus Jensen <cje_at_stibo.com> wrote in article
> <34D35079.7C2B_at_stibo.com>...
> > Is there a way (that does not involve reinstalling Oracle!) to
 change
> > the maximum number of datafiles that is set on during installation.
> >
> > It's easy enough to change the "db_files" init.ora parameter, but
> > unfortunately you can set that to any value you like and you do not
 get
> > any warning until you try to exceed the "hard" maximum set during
> > install. So what does it take to change that value?
> >
> > Is there any negative side to setting a high value of this parameter
 

> > during install? I would think that only the actual number of
 datafiles
> > affects performance.
> >
> > Thanks for any advice. Please also reply by mail.
> >
> > --
> > ------------------------------------------------------------------
> > Claus Jensen The Stibo Technology Group...since 1794
> > Stibo Datagraphics Inc.
> > 400 Franklin Road E-mail: cje_at_stibo.com
> > Marietta Phone: (001) 770 425 3282, ext. 197
> > GA 30067-7735 Fax: (001) 770 425 3012
> > ------------------------------------------------------------------
> > "If the human brain was simple enough for us to understand,
> > we would be so simple we couldn't..."
> > ------------------------------------------------------------------
> >
Received on Thu Feb 05 1998 - 00:00:00 CST