file extensions

Hi,

Using file extensions is a convention.For datafile it is .dbf.But if we use other extension,how oracle determines it is a datafile ? I would want info for other files also.

Thanks.

---Radha

When you create a tablespace, you specify the path and name of the datafile. This is how Oracle determines it is a datafile. You can give it any extension you wish.

Different sites use different naming standards:
data files - .dbf, .dat, .df
control files - .dbf, .ctl, .cf
redo logs - .log, .rdo

Jeff is right but its upto you what kind of ext you want to use.
BTW it does not matter so much because whole path gets stored in the dictionary views.

Naresh