Re: Question on MAXDATAFILES and Control Files.

From: William Dieterich <wdieteri_at_rmi.net>
Date: Tue, 31 Oct 2000 22:04:40 -0700
Message-ID: <39FFA468.AFB4BF38@rmi.net>

> A fellow-instructor told me two weeks ago that db_files in the init.ora
> actually dynamically overcomes the limitations of a too-low maxdatafiles
> setting, so that you don't have to re-create the controlfile if you hit the
> limit. Magic if so, but I remain sceptical. Put it this way, I haven't
> gone to the effort of testing it!
>

Thanks for the info on size, and the verification that it is just the size of your control file that is affected.

It was in Oracle8 that they changed MAXDATAFILES works so that it now determines the amount of space set aside in the control file for the number of datafiles at the time you initial create the database, however if you go over this number the control file will expand automatically. Received on Tue Oct 31 2000 - 23:04:40 CST