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

What is the file extension of an Oracle database?

What is the file extension of an Oracle database?

There are two possible answers to your question, depending on how you are using the word "extension".

First, files typically have an extension to the file name. The file extension is the part after the period in the filename. Many DBAs typically use the ".dbf" file extension for Oracle datafiles to signify that this datafile is a database file, or dbf. But you can use anything you want. The Oracle database does not dictate the file extension. It is just a common practice to use this file extension.

Second, Oracle database datafiles can be set up to automatically extend if the datafile is too small to hold new data. This extension can be defined by the DBA and managed by the system. To set a datafile to autoextend, use the following command:

ALTER DATABASE DATAFILE '/somedir/filename.dbf'
AUTOEXTEND ON NEXT 100M MAXSIZE 500M;
The above command turns on the autoextend feature for just this particular datafile. If more room is needed, this file will grow in chunks of 100MB, up to a maximum file size of 500MB.

I'm not sure which answer is for your question, but hopefully I've covered both bases.

For More Information


This was last published in February 2003

Dig Deeper on Oracle database design and architecture

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.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close