DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: file extensions

  1. 12-01-2000, 06:12 PM #1
    rsonnathi
    rsonnathi is offline Junior Member
    Join Date
    Dec 2000
    Posts
    32
    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
    Reply With Quote Reply With Quote
  2. 12-01-2000, 06:17 PM #2
    mhaller
    mhaller is offline Member
    Join Date
    Apr 2000
    Posts
    126

    Wink 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.
    Reply With Quote Reply With Quote
  3. 12-01-2000, 06:31 PM #3
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    Different sites use different naming standards:
    data files - .dbf, .dat, .df
    control files - .dbf, .ctl, .cf
    redo logs - .log, .rdo
    Jeff Hunter
    Reply With Quote Reply With Quote
  4. 12-01-2000, 09:01 PM #4
    ngupta15
    ngupta15 is offline Junior Member
    Join Date
    Jun 2000
    Location
    Santa Clara, CA, USA
    Posts
    12
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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