Re: Max DB Files

From: Robert W. Swisshelm <swisshelm_at_lilly.com>
Date: 1996/08/05
Message-ID: <32064448.682B_at_lilly.com>#1/1


B C Zygmunt wrote:
>
> I'm a DBA who's also filling in for another DBA on extended leave. On this
> other system, I've run into a problem when trying to add a database file. The
> max value was set to 30 (db_files = 30) in the init.ora file. I increased it to
> 40, shutdown and restarted the database. When I tried to add the datafile, I
> got Oracle error 1118:
>
> 01118, 00000, "cannot add any more database files: limit of 30 exceeded"
> // *Cause: Obvious
> // *Action:
>
>
> Beverly Zygmunt
> Oak Ridge National Lab

There is a parameter on the CREATE DATABASE command that defines the hard limit for the number of database files. It is the MAXDATAFILES option.

As you have found out, this is the real maximum value, not DB_FILES.

To change it, you must recreate your control file. The process for doing this is documented in chapter 6 of the Version 7.2 Database Administrator's Guide.

The process is pretty easy, although it is scary the first time you do it.

Good Luck!

-- 
Bob Swisshelm
Eli Lilly and Company
swisshelm_at_lilly.com
Received on Mon Aug 05 1996 - 00:00:00 CEST

Original text of this message