Re: max db_files on 7.2.3

MarkP28665 wrote:
>
> 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.
> >
> Reply was >> Check maxdatafiles
>
> If this in on a Unix system check the OS Oracle user resource limits,
> i.e., ulimit.
>
>
> Mark Powell -- The only advise that counts is the advise that you follow
> so follow your own advise

When database was created maxdatafiles was set to 30 or the default was used. You can reset the maxdatafiles by recreating the control files. prior to a full backup enter a sql command alter database backup control file to trace; this will create a trace file in the user trace files location. You can edit this trace file to change the maxdatafiles to a larger value. Save the old control files. startup the database in mount mode. run the edited trace file in svrmgr or sqldba. then alter the database open.

If you need more detail email me. Dick Allie - dallie_at_ionet.net Received on Mon May 05 1997 - 00:00:00 CDT