Re: How to change MAXDATAFILES?

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: 15 Jan 2002 22:34:49 -0800
Message-ID: <a8aed4.0201152234.223827cc@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 - 00:34:49 CST