Re: maxdatafiles

From: Chuck Wolfe <cwolfe_at_ix.netcom.com>
Date: 1997/02/08
Message-ID: <32fcab94.601734456@nntp.ix.netcom.com>#1/1

JJ,

In order to increase the MAXDATAFILES parameter, you DO NOT need to recreate the database. You do however, need to create a new controlfile for the database with the increased value for MAXDATAFILES specified. This is also where you would change the values for other PERMANENT database parameters: MAXLOGFILES, MAXLOGMEMBERS, etc. Consult the Administrator's Guide for more detailed information/instructions. As a rule, it is a good practice to specify a large value for these parameters at initial database creation as the default values for most systems tend to be fairly small.

Exercise caution in doing this, make sure you have a reliable backup of the database and all its associated system files (controlfiles, redo logs, etc).

>OK.. the documentation sais that to increase macdatafiles, you need to
>recreate the database. How do you go about recreating the database?
>Our DB was installed by a vendor we (for the most part) no longer
>use and as the DBA I need to learn it anyway....
>
>I know a little about the exp and imp utilities--is this how it should
>be done? What are the pitfalls? What things should I look out for?
>
>
>TIA,
>
>
>jjr_at_healthfare.com

hope this helps.

Regards,

Chuck Wolfe
Manager, Database Services
NDC Group, Inc.
625 Slaters Lane, Suite 102
Alexandria, VA 22314
cwolfe_at_ndcinc.com Received on Sat Feb 08 1997 - 00:00:00 CST