Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle data file format

Re: Oracle data file format

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Fri, 7 Jun 2002 06:40:23 +0100
Message-ID: <3d00474a$0$231$cc9e4d1f@news.dial.pipex.com>


I think I can. In some windows versions the default file extension (if you use the GUI) for data files is .ORA, in others it s .DBF So the answer to the second question is "there is no difference between datafiles on a windows platform even if the extension is different" . You however cannot transfer datafiles from one OS to another because then they really are different, the only way that I would consider for transferring data from Windows to Unix would be export/import.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"RSH" <RSH_Oracle_at_worldnet.att.net> wrote in message
news:uVWL8.25031$LC3.1894756_at_bgtnsc04-news.ops.worldnet.att.net...

> I greatly apologize, but I cannot understand either the issue, or contrive
a
> solution, from this message. Could you elaborate a little bit?
>
> Thanks.
>
> RSH.
>
>
> "Henry Lau" <henryl_at_asper.com.hk> wrote in message
> news:adpchk$7rk$1_at_hfc.pacific.net.hk...
> > Hi,
> >
> > I am using windows 2000 and oracle 8.1.6 Is any one know why my
> database
> > files format is ORA ? what is the different between ORA and DBF??
> > Is it possible to restore the DBF to Unix Oracle database??
> >
> > Henry
> >
> >
>
>
Received on Fri Jun 07 2002 - 00:40:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US