I do not use the CTL extension for database control
files as it is used by sql*loader control files.
I'm using dbf for all data files including data,
indexes, temp or rbs. The naming of the files shows
what the file contains.
I do not think different extensions could lead to
problem but I would change it so the naming is
consistent across all databases.
Have a look at Bill Burke's document Putting OFA on
Steroids at www.oracleguru.com
HTH
- "O'Neill, Sean" <Sean.ONeill_at_organon.ie> a
écrit : > Saurabh,
>
> My views are that I tend to use datafile extentions
> to reflect the type of
> tablesapces I use in the file or the file type:
> For example:
> .DBF for datafile
> .RBS for Rollback
> .ARC for Archived redo logs (can confuse Winzip
> utility on Windoze)
> .RDO for Online Redo
> .CTL for control file
>
> In terms of conversion or upgrades they should not
> matter AFAIK as physical
> and logical storage are separate in Oracle.
>
>
> Sean :)
>
> Rookie Data Base Administrator
> Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K
> [0%] OCP Oracle8i DBA
> [0%] OCP Oracle9i DBA
> -------------------------------- ------------
> Organon (Ireland) Ltd.
> E-mail: sean.oneill_at_organon.ie [subscribed: Digest
> Mode]
>
> Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA
>
> "Nobody loves me but my mother... and she could be
> jivin' too." - BB King
>
> > From: "Saurabh Sharma" <ssharma1_at_fcsltd.com>
> > Date: Tue, 31 Jul 2001 12:44:03 +0530
> > Subject: using ora & dbf as datafile extensions..
> >
> >hi all,
> >
> >is there any problems using different filetypes for
> various datafiles in =
> >the same database.
> >i mean using some files as .dbf extension while
> some as .ora
> >
> >i'm using system, rbs, temp, oemrep as .dbf, while
> the one i creted =
> >later are using .ora extension.
> >does it cause any problem in conversion or
> upgradation.
> >
> >any views.
>
> Saurabh Sharma
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: O'Neill, Sean
> INET: Sean.ONeill_at_organon.ie
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
stephane_paquette_at_yahoo.com
Do You Yahoo!? -- Vos albums photos en ligne,
Yahoo! Photos :
http://fr.photos.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?paquette=20stephane?=
INET: stephane_paquette_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Jul 31 2001 - 06:23:00 CDT