Re: Altering max datafiles set on installation?

[Quoted] [Quoted] Sorry, but my understanding is that you have to rebuild the database. (You [Quoted] 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.
>
> --
> ------------------------------------------------------------------ [Quoted]
> 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 CET