Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle data file format
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...Received on Fri Jun 07 2002 - 00:40:23 CDT
> 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
> >
> >
>
>