Re: Limit on the number of datafiles

I believe the default maxdatafiles parameter is OS dependent but on most systems I have seen (HPUX,SOLARIS,DRS/NX) it seems to default to 30. Also you need to realise that increasing maxdatafiles will impact the size of your control files.

Nigel Rudgyard wrote in message
<890339083.17340.0.nnrp-09.c1ed0cd9_at_news.demon.co.uk>...
>The reason why you specify it at database creation time is because the
>control file needs to be sized accordingly.
>
>As for the default, I've no idea of the top off my head, but I suspect that
>you'll find it specified in the appropriate manuals.
>
>Note that if you need to increase the maximum value once your database has
>been created then simply dump the control file to trace, edit it
 accordingly
>and create yourself a new control file (remember to back your database up
>1st just in case anything goes wrong).
>
>Terry Heung-Man Lam wrote in message <6erm0i$n4_at_ringding.cs.umd.edu>...
>>Hi,
>>
>>If during database creation, I don't specify maxdatafiles but I specify
>>it in the init.ora file (i.e. db_files = 100) after the database is
 created,
>>what will be the upper limit for the number of datafiles? Is there an
 internal
>>default limit on the number which will overwrite init.ora if the internal
>>default limit is smaller than db_files = 100?
>>
>>My environment is Oracle 7.3.4 and Sun Solaris 2.5.
>>
>>Thanks in advance.
>>-Terry
>>
>
>
Received on Fri Mar 20 1998 - 00:00:00 CST