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-
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
KG,
you cannot increase the db_files parameters beyond the MAXDATALIFLES number.
Oracle reserves space for storing the info about individual datafiles in the
control files depending upon the MAXDATAFILES.
To increase the number of datafiles beyond this limit, you have to recreate
the Control
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
KG,
This is from 9i Manual:
DB_FILES:
Parameter type Integer
Default value 200
Parameter classStatic
Range of values
Minimum: the current actual number of datafiles in the
database
Maximum: the value that was specified
Not sure from which manual it is mentioned. In any case
the manual is incorrect for Oracle8 and above versions.
You **CAN** create the datafiles than MAXDATAFILES
if you have specified db_files parameter greater than
the MAXDATAFILES.
You may want to file a Documentation BUG on that Manual.
THis one is from pg 876 of Oracle9i SQL Reference
PArt # A90125-01
*BEGIN QUOTE
MAXDATAFILES Clause
Specify the initial sizing of the datafiles section of the control file at
CREATE
DATABASE or CREATE CONTROLFILE time. An attempt to add a file whose number
is greater than
Well, point taken. I'll try and test it too when I get time.
My point came from the DB Reference Guide, 9i Release 2. You can also see the
same point in the SQL Reference in ALTER SYSTEM command. Maybe it is
out-dated.
That caused the confusion.
Regards
Naveen
-Original Message-
Sent: