OraFAQ Forum: Server Administration » db

Home » RDBMS Server » Server Administration » db_files and maxdatafiles

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

db_files and maxdatafiles [message #194541]

Fri, 22 September 2006 10:18

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

Report message to a moderator

Re: db_files and maxdatafiles [message #194597 is a reply to message #194541]

Fri, 22 September 2006 19:53

email.sandeepnaik
Messages: 121
Registered: August 2006

Senior Member

db_files governs max limit of datafiles (excluding tempfiles)

Sandeep

Report message to a moderator

Re: db_files and maxdatafiles [message #194988 is a reply to message #194541]

Tue, 26 September 2006 07:53

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 ?

Report message to a moderator

Re: db_files and maxdatafiles [message #194992 is a reply to message #194988]

Tue, 26 September 2006 08:03

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.

Report message to a moderator

Re: db_files and maxdatafiles [message #194995 is a reply to message #194541]

Tue, 26 September 2006 08:07

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

Great ans: .Thanks for the clarification

Report message to a moderator

Previous Topic:	How to jump over a trigger
Next Topic:	Drop datafile from tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 21 03:49:19 CDT 2026