Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to increase max. no. of datafiles in a database?
From 8I, you no longer have to recreate the control files. Just increase db_files.
HTH, Leng.
Martin Haltmayer wrote:
> You have to recreate your control file *and* you have to modify your db_files
> parameter.
>
> Martin
>
> David YEUNG wrote:
> >
> > I want to increase the maximum of datafiles in a database which have been
> > created and used for a while. In the 'init.ora' file, I see a few lines like:
> >
> > db_files = 80 # SMALL
> > # db_files = 400 # MEDIUM
> > # db_files = 1500 # LARG
> >
> > Can I simply modify the db_files to a larger number and restart the database,
> > or I need to do more?
> >
> > Thanks for advice
> >
> > david
Received on Thu Aug 17 2000 - 21:24:10 CDT