Re: Oracle6.0.36 MAX_DATA_FILES problem

Peter H. Larsen wrote:
>
> 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

Did you try a CREATE CONTROLFILE?
You may be surprised.

Regards
Eric Received on Thu Oct 23 1997 - 00:00:00 CDT