Not quite true. Starting from Oracle8 you don't need to recreate the controlfile to increase the MAXDATAFILES parameter.
You can just change the db_files and bounce the server. KG -----Original Message----- Khanna Sent: Thursday, September 19, 2002 1:43 AM To: Multiple recipients of list ORACLE-L KG, It will not help just by increasing the db_files parameter in the Init.ora file. Whenever you need to change MAXDATAFILES,MAXLOGFILES,MAXLOGMEMBERS for your database the change is to recreate the control file and then mount and open the database. What needs to be done is : Svrmgr> Alter database backup controlfile to TRACE; This would generate an ASCII text based file at the location defined by USE_DUMP_DEST in your init.ora. Edit that file in any text editor and chane the Value of MAXDATAFILES (in your case). Save the file with some name at a particular destination.eg C:\Controlfile\Control.Sql SVRMGR> Shutdown immediate; Instance Shutdown. SVRMGR>Startup Nomount; Instance Started. SVRMGR>@C:\Controlfile\Control.Sql; Statement Processed. SVRMGR> Alter database mount; Database Mounted. Svrmgr> Alter database open; Database opened. Now you can create the new datafiles to expand your database. Never the parameter db_files can be more that the MADATAFILES declared in your controlfile; Thanks Vikas Khanna -----Original Message----- Sent: Thursday, September 19, 2002 1:28 PM To: Multiple recipients of list ORACLE-L George: If you want to recreate the controlfile **just to ** increase the max datafiles, you can simply increase the db_files parameter and bounce the database. This will automatically chance the max datafiles settings when you create the additional datafiles. KG -----Original Message----- Leonard (ZA) Sent: Thursday, September 19, 2002 12:13 AM To: Multiple recipients of list ORACLE-L Hi all Does someone maybe have a step by step guide to re-creating the control files. I have found that one the my databases the maxdatafiles has been set to small, would like to increase it now. thx George ________________________________________________ George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ********************************************************************** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Leonard (ZA) INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Khanna INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).