Home » RDBMS Server » Server Administration » "ORA-00059: MAXIMUM NUMBER OF DB_FILES exceeded"
"ORA-00059: MAXIMUM NUMBER OF DB_FILES exceeded" [message #222130] Fri, 02 March 2007 00:07 Go to next message
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
Re: "ORA-00059: MAXIMUM NUMBER OF DB_FILES exceeded" [message #222137 is a reply to message #222130] Fri, 02 March 2007 00:23 Go to previous messageGo to next message
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





Re: "ORA-00059: MAXIMUM NUMBER OF DB_FILES exceeded" [message #222897 is a reply to message #222130] Tue, 06 March 2007 21:34 Go to previous messageGo to next message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
great answer
in the init.ora file you can find that parameter.
Re: "ORA-00059: MAXIMUM NUMBER OF DB_FILES exceeded" [message #222905 is a reply to message #222897] Tue, 06 March 2007 23:05 Go to previous message
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
Previous Topic: Excel,text Data through ODBC in Oracle
Next Topic: Installing Oracle on Unix
Goto Forum:
  


Current Time: Mon Dec 05 23:58:57 CST 2016

Total time taken to generate the page: 0.08311 seconds