Home » RDBMS Server » Server Administration » Maxdatafiles exceeded at the database (oracle 9i R2 IBM AIX)
Maxdatafiles exceeded at the database [message #320023] Tue, 13 May 2008 13:55 Go to next message
pokhraj_das
Messages: 64
Registered: February 2008
Member

Hi,

I want to add a datafile to the tablespace but I am getting an error that max datafiles exceeded.

How can I troubleshoot the problem.

Pokhraj
Re: Maxdatafiles exceeded at the database [message #320025 is a reply to message #320023] Tue, 13 May 2008 14:00 Go to previous message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>How can I troubleshoot the problem.
There is nothing to 'troubleshoot'.

You need to create control file(s) a larger MAXDATAFILES value
Re: Maxdatafiles exceeded at the database [message #320026 is a reply to message #320023] Tue, 13 May 2008 14:00 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post the exact error message.
Just copy and paste it.
It is far much easier than trying to type it.

Regards
Michel
Previous Topic: ASM on Suse linux 10
Next Topic: Ora-600 diagnosis.....
Goto Forum:
  


Current Time: Sat Dec 03 03:37:54 CST 2016

Total time taken to generate the page: 0.08694 seconds