 MAX DATAFILES [message #181474] |
Mon, 10 July 2006 05:07  |
abs_amit
Messages: 59
Registered: January 2006
Location: delhi
|
Member |
|
|
Hi all
i am using oracle 10g R-2.
in controlfile parameter maxdatafiles 256.
but still it allows me to add more than 256 datafiles.
Total datafiles in database are 257 Why????????
|
|
|
|
| Re: MAX DATAFILES [message #181482 is a reply to message #181474] |
Mon, 10 July 2006 05:30  |
Frank Naude
Messages: 4593
Registered: April 1998
|
Senior Member |
|
|
Check the SQL Reference guide (CREATE DATABASE statement):
"MAXDATAFILES: 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 MAXDATAFILES, but less than or equal to DB_FILES, causes the Oracle Database control file to expand automatically so that the datafiles section can accommodate more files."
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
