Re: max db_files on 7.2.3

From: Brian Michael <eapg_inc_at_earthlink.net>
Date: 1997/05/06
Message-ID: <336F76DC.6785@earthlink.net>#1/1

suvas wrote:
>
> Check maxdatafiles
>
> Baan Canada <Rob_Van_Brandenburg_at_baan.com> wrote in article
> <01bc405e$8b58fe20$e9edb6ce_at_robvb.BAANAM>...
> > Running Oracle 7.2.3.
> > Can't create more than 30 datafiles !
> > db_files = 100
> >
> > Suggestions ?
> >
> > Rob.
> >

At database creation time, you specify the maximum number of files to you can create with this database. The ini parameter becomes basically meaningless and you have to re-create the database. This parameter is only for the current instance. Not for the database.

Instance = Database + Memory + processes. Database = Physical Disk Data Files + Control Files + Log Files

Check out the manual (server guide section 2.9, and 7.3) Also check out the Create Database Syntax.

Create Database xxxx
maxdatafiles ### Received on Tue May 06 1997 - 00:00:00 CDT