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