Oracle File Extension - EASY QUESTION

[MeatLander]

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 = *.??? | *.???

[MeatLander]

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.

[davide++]

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

[codeexpert123]

.dbf is used for an Oracle 8.x Tablespace File