Problem solve Get help with specific problems with your technologies, process and projects.

Maximum limit Oracle DBMS datafiles

Oracle expert Brian Peasland discusses how to control the maximum number of datafiles in a database.

How do DB_FILES & MAXDATAFILES control the number of datafiles in Oracle DB? How do you check the maximum limit on the number of datafiles in Oracle DB on a different OS platform?
The DB_FILES parameter updates the MAXDATAFILES number in the control file. Luckily, you can increase your max number of datafiles, up to the platform limit. When one creates a new datafile in the database, the control file is consulted to ensure the max has not been reached.

To check how many files your platform supports, for your version, consult the platform specific documentation.

This was last published in February 2008

Dig Deeper on Oracle database administration

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.