Re: Oracle6.0.36 MAX_DATA_FILES problem

Hi,
It's been a while since I've worked with Oracle 6, but as far as I remember you have a MAX DATA FILES in your ALTER DATABASE and/or in your database-initialization parameters (init.ora). The later should be tunable just by changing the value. If it's only available using ALTER DABASE, open the database in NOMOUNT mode and try to alter the value.

• Peter H. Larsen

Narayan Prabakar wrote:

> I have an Oracle 6.0.36 database that does not want to open up and cites
> the reason to be something like
>
> "max. datafiles exceeded - you have more than 62 datafiles files in your
> database"
>
> How do you get around this problem in ver 6.0.36? The problem started
> when I added a datafile to increase the "TEMP" tablespace and then
> bounced the database.
>
> I have not been successful in using the command "ALTER DATABASE BACKUP
> CONTROLFILE TO TRACE".
>
> Any response would be appreciated.
>
> - Sam
Received on Thu Oct 23 1997 - 00:00:00 CDT