Re: Oracle6.0.36 MAX_DATA_FILES problem

In article <877443705.26486.0.nnrp-02.9e985eb5_at_news.demon.co.uk>,   "Ian Chalcraft" <iac_at_smcewan.demon.co.uk> wrote:
>
>
> 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

There is an undocumented way. However, it involves using ALTER DATABASE BACKUP CONTROLFILE TO TRACE - which won't help Narayan Prabakar.

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet