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;
I'm not sure which answer is for your question, but hopefully I've covered both bases.
For More Information
- Dozens more answers to tough Oracle questions from Brian Peasland are available.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.