Re: How to change MAXDATAFILES?

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Wed, 16 Jan 2002 22:47:14 +0800
Message-ID: <a243q3$3qv$1@dahlia.singnet.com.sg>

Ganesh,

The DB_FILES parameter, even if you set it higher than the value of MAXDATAFILES,
cannot really increase the maximum number of datafiles. DB_FILES is normally set to lower than MAXDATAFILES (conversely, MAXDATAFILES is set high when creating the database or recreating the controlfiles).

Hemant K Chitale

"Ganesh Raja" <ganesh_at_gtfs-gulf.com> wrote in message news:a8aed4.0201152234.223827cc_at_posting.google.com...
> tho_pic_at_yahoo.com (Tho Nguyen) wrote in message
news:<d177c6d9.0201140200.50df11a4_at_posting.google.com>...
> > "Eric" <h9515895_at_sinatown.com> wrote in message
news:<a1tja5$pno$1_at_hfc.pacific.net.hk>...
> > > Hi,
> > >
> > > I want to change the MAXDATAFILES in the init.ora file. As I know, I
need to
> > > re-create the control file. What is the correct steps to change it?
Pls
> > > check it for me ... Thanks
> > >
> > > 1) change the parameter MAXDATAFILES in init.ora
> > > 2) startup nomount
> > > 3) alter database create controlfile to '/directory'
> > > 4) alter database open
> > >
> > > Pls, correct my wrong step and give me advices
> > >
> > > Thanks again
> > > Eric Wong
> >
> > What's your Oracle Version?
> > If you use Oracle7, you have to recreate the controlfile, if Oracle 8
> > just change the db_file in init.ora.
>
> What Will hapen if i change my Db_Files Parameter... the Db_Files
> Parameter Specifies the Number of files that can be opened by an
> instance at one time.
>
> Regards,
> Ganesh R
Received on Wed Jan 16 2002 - 08:47:14 CST