Re: How to increase max. no. of datafiles in a database?

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 Sat Aug 12 2000 - 00:00:00 CDT