Re: Please Help !!!DB_FILES exeded

Hi,
If an ora-1118 error arises, this means that your database has hit the MAXDATAFILES limit, it is not a problem with the DB_FILES parameter, because if it was, an ORA-59: 'maximum number of DB_FILES exceeded' would arise.

This error occurs because you have hit the hard limit for the number of data

files. The following are possible options to get around this problem:

1. Reduce the number of datafiles associated with each individual tablespace. For example, if you have a tablespace with three 100 Meg datafiles, recreate the tablespace with just one 300 Meg datafiles. The easiest way to do this would be to export all of the objects out of that tablespace. Drop the tablespace. Recreate it with just one datafile, and then import the objects back in.
2. Recreate the database. Since the MAXDATAFILES parameter is specified upon database creation, recreating the database allows you to increase this parameter. NOTE: If the database is running 6.0.33.0 or earlier, this is your only option to increase the MAXDATAFILES limit.
3. Increase the MAXDATAFILES parameter. If you are running v6.0.33.1 or higher, it is possible for you to increase the MAXDATAFILES limit without recreating the entire database. This is done by recreating the control file only.

John Durst wrote:

> DB_FILES is an init.ora paramter that can be increased as long as you do
> not exceed the value specified in the control file for MAXDATAFILES when
> the database was created. You must modify the parameter file, and then
> shut down and restart the instance for the change to take effect.
>
> Fernando Carter wrote:
>
> > I don't know the exact massage in english but I'm getting
> > maximun DB_FILES number exceded.
> >
> > What can I do , is this a parameter for the server?
> > Where do I config This
> >
> > Please Help.
> > Thanks in advance.
> >
> > Fernando Carter
Received on Mon Oct 19 1998 - 13:39:58 CDT