OraFAQ Forum: Server Administration » "ORA-00059: MAXIMUM NUMBER OF DB

Home » RDBMS Server » Server Administration » "ORA-00059: MAXIMUM NUMBER OF DB_FILES exceeded"

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

"ORA-00059: MAXIMUM NUMBER OF DB_FILES exceeded" [message #222130]

Fri, 02 March 2007 00:07

prasadsure
Messages: 3
Registered: March 2007
Location: Bangalore

Junior Member

Hi all

I was creating a new tablespace and I got this error message
"ORA-00059: MAXIMUM NUMBER OF DB_FILES exceeded"

How can find out where we can specify MAX_no.of data table space.

Our server is HP_UX server version B11.23

Please suggest me.

Regards
S.Prasad

Report message to a moderator

Re: "ORA-00059: MAXIMUM NUMBER OF DB_FILES exceeded" [message #222137 is a reply to message #222130]

Fri, 02 March 2007 00:23

Muhammad Ahmad
Messages: 30
Registered: November 2002

Member

Hi,

I think u should check

the initialization parameter "db_files"
& need to extend that limit.

Looking for your feedback
Good Luck!!!

Regards,

Sunny

Report message to a moderator

Re: "ORA-00059: MAXIMUM NUMBER OF DB_FILES exceeded" [message #222897 is a reply to message #222130]

Tue, 06 March 2007 21:34

nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...

Senior Member

great answer
in the init.ora file you can find that parameter.

Report message to a moderator

Re: "ORA-00059: MAXIMUM NUMBER OF DB_FILES exceeded" [message #222905 is a reply to message #222897]

Tue, 06 March 2007 23:05

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
In addition of other member.
You should increase DB_FILES parameter.
and it is not modifiable so you have to

shutdown >>> edit init.ora >> create spfile from init.ora >>> startup

regards
Taj

Report message to a moderator

Previous Topic:	Excel,text Data through ODBC in Oracle
Next Topic:	Installing Oracle on Unix

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 04:47:05 CST 2025