Home » RDBMS Server » Server Administration » db_files and maxdatafiles
db_files and maxdatafiles [message #194541] Fri, 22 September 2006 10:18 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Hi,
In my pfile i have db_files = 1024
and controlfile,maxdatafiles=6 .
currently i have 6 datafiles,and now i added one more datafile .By that i expected an error saying "maxdatafiles reached" .But i didnot received any error .

i took a backup of control file and found maxdatafiles=7 (it automaticaly increased by one ) Mad
Re: db_files and maxdatafiles [message #194597 is a reply to message #194541] Fri, 22 September 2006 19:53 Go to previous messageGo to next message
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
db_files governs max limit of datafiles (excluding tempfiles)

Sandeep
Re: db_files and maxdatafiles [message #194988 is a reply to message #194541] Tue, 26 September 2006 07:53 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Sorry thts not ans: to my question .
How control file value increasing by one,on addition of each file ?
Re: db_files and maxdatafiles [message #194992 is a reply to message #194988] Tue, 26 September 2006 08:03 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
sandeepnaik's answer is correct. The MAXDATAFILES will be incremented automatically up to the DB_FILES limit. Even if you were to drop the tablespaces and it's corresponding datafiles, MAXDATAFILES will still show 7.
Re: db_files and maxdatafiles [message #194995 is a reply to message #194541] Tue, 26 September 2006 08:07 Go to previous message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Great ans: .Thanks for the clarification
Previous Topic: How to jump over a trigger
Next Topic: Drop datafile from tablespace
Goto Forum:
  


Current Time: Sat Dec 03 08:03:34 CST 2016

Total time taken to generate the page: 0.11305 seconds