Re: Oracle6.0.36 MAX_DATA_FILES problem

Narayan Prabakar wrote in message <344BAC80.F1B55BE8_at_ix.netcom.com>...
>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
>
>
>

BACKUP CONTROLFILE TO TRACE is an Oracle7 Server facility for recreating your
control files, hence it will not work with Oracle 6.

In the Oracle RDBMS DBA Guide version 6, it has this to say re: MAXDATAFILES The number specified at the time of database creation is the absolute limit for that
database. It can only be increased by re-creating the database.

I have heard that there is an undocumented method for changing this parameter
within an Oracle 6 database, but do not know of it myself :-( Maybe there is a
guru out there who can offer more help.

• Ian