Re: Maxdatafiles problem

No need to recreate the database.

The controlfile also has a limit on the number of files. Unfortunatelly for 7.x databases and below this number is fixed. You will have to recreate the controlfile when this happens. And yes, you have to be careful with that. (take backup, test it on a toy database, RTFM, etc)

For Oracle 8.x the rdbms will automatically allocate more space in the controlfile.
So you might consider an upgrade first.

Erwin

Ivan wrote:
>
> Hi,
>
> When I created my database I didnīt specify the maxdatafiles parameter. Then
> the default value is 30. Now I need more than 30 datafiles, I put in my
> init.ora the parameter DB_FILES=100, stop and start the instance, but when
> I try to create a new datadife ORACLE say me that I have the maximum number
> of datafiles (30).
>
> What can i do?, do you think taht I have to re-create my database?
>
> Thanks in advance.
>
> Please send me a e-mail : ivan.mingot_at_ua.es

--
Erwin Dondorp
<http://www.dondorp.com/> Received on Fri Oct 29 1999 - 09:42:27 CDT