Re: Limit on the number of datafiles

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 Thu Mar 19 1998 - 00:00:00 CST