Re: How to increase max. no. of datafiles in a database?

From: Scott A. Haas <sahaas_at_lazerlink.com>
Date: Mon, 14 Aug 2000 22:31:55 -0400
Message-ID: <3998AB9B.70592E19@lazerlink.com>

You'll need to do the following steps to recreate a control file ...

svrmgrl> connect internal
svrmgrl> alter database backup controlfile to trace;
svrmgrl> exit

unix> cd $ORACLE_BASE/admin/<SID>/bdump modify the newest trace file in this directory ..... set MAXDATAFILES to whatever you want ..... remove all information from the top of file, up to and including the startup nomount line

svrmgrl>  shutdown immediate
svrmgrl>  startup nomount
svmrgrl>  start  <trace file you just created>

this should recreate your control files .... shutdown and restart database normally .... svrmgrl> alter database backup controlfile to trace; svrmgrl> exit
review newest trace file to ensure MAXDATAFILES is set to what you want

Martin Haltmayer wrote:

> You have to recreate your control file *and* you have to modify your db_files
> parameter.
>
> Martin
>
> David YEUNG wrote:
> >
> > I want to increase the maximum of datafiles in a database which have been
> > created and used for a while. In the 'init.ora' file, I see a few lines like:
> >
> > db_files = 80 # SMALL
> > # db_files = 400 # MEDIUM
> > # db_files = 1500 # LARG
> >
> > Can I simply modify the db_files to a larger number and restart the database,
> > or I need to do more?
> >
> > Thanks for advice
> >
> > david
  Received on Mon Aug 14 2000 - 21:31:55 CDT