Home....
Developer Network >> Other Programming >> Database

Oracle File Extension - EASY QUESTION

What is the extension for an oracle database file?
What is the extension for an oracle log file?
IE: Access = *.mdb
SQL Server = *.mdf | *.ldf
Oracle = *.? | *.?
[182 byte] By [MeatLander] at [2007-11-20 10:36:10]
«« Successfully Killing A Thread
»» CRichEdit control question
# 1 Re: Oracle File Extension - EASY QUESTION
I figured it out... Oracle uses this crazy Enterprise thing that allows users to create their own file extensions... or something. By default, the only extension I could find was *.dbf and *.ora so I'm going to use those. If those are wrong, the user can always select "Show all files" from the combo box in the Open File Dialog and select whatever (s)he wants.
MeatLander at 2007-11-9 13:45:32 >
# 2 Re: Oracle File Extension - EASY QUESTION
Hi all

Oracle is very different from others databases such as Access or SqlServer.
Oracle hasn't file in the sense of "document", as Access.
Of course, data are stored into one or more file on disk, but this isn't managed by a kind of Save As command: Oracle works with tablespaces, that are logical group of files and users don't see these files (they haven't to see them).
When one creates a tablespace has to specify one (or more) file where to store data; usually these file have .dbf as extension
davide++ at 2007-11-9 13:46:33 >
# 3 Re: Oracle File Extension - EASY QUESTION
.dbf is used for an Oracle 8.x Tablespace File
codeexpert123 at 2007-11-9 13:47:32 >
Other Programming
Database

Other Programming

All Classified

Other Programming New Topic

Other Programming Hot Topic