OraFAQ Forum: Server Administration » Maxdatafiles exceeded at the database

Home » RDBMS Server » Server Administration » Maxdatafiles exceeded at the database (oracle 9i R2 IBM AIX)

Tue, 13 May 2008 13:55

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

Tue, 13 May 2008 14:00

BlackSwan
Messages: 26766
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

Tue, 13 May 2008 14:00

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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: Fri Nov 29 22:41:22 CST 2024