-
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
-
file extensions
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 Hunter
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|