Re: db_files

Doug

What was MAXDATAFILES set to when the database was created? Probably left at 30, the default. Check by doing an ALTER DATABASE BACKUP CONTROLFILE TO TRACE and look at the create controlfile syntax in the trace file. You can recreate the controlfile with a greater value to get rid of the error.

HTH. Pete

Doug Cowles wrote:

> I recently tried to add a datafile, and got a message similar to the
> following:
> Cannot create database file, maximum of 30 reached.
> Then, it went ahead and made the file, although it isn't in the data
> dictionary.
> What's stranger though, is that the db_files is set to 40, not 30, if
> you do a show
> parameter db_files, you get 40. What gives here?
>
> - Dc.

Received on Fri Sep 24 1999 - 15:31:42 CDT