Re: copy Oracle *.dbf file from one OS to another

"Vincent CASBAS" <vincent.casbas_at_tlse.altior.fr> wrote in message news:3B83F2F1.2D84510_at_tlse.altior.fr...
> Vincent Ventrone wrote:
>
> > > do this from Digital box to another Digital box. But would like to
know if
> > > it can be done to another OS platform. If not why ? maybe some one can
> > > explain ?
> >
> > No - not possible because the file formats, instruction set, etc.
differ.
> > You need to create a new, empty database on the target platform & do a
full
> > db export/import to move the contents.
>
> I think now it is possible with Oracle transportable tablespaces. You can
write
> a tablespace (one or more files) to a CD and then send it by mail to
another
> server.
>
> Regards
>
> --
> -----------------------------------------------------------
> Vincent CASBAS vincent.casbas_at_tlse.altior.fr
> +33-(0)562249936
> Consultant SGBD/R Oracle
> ALTIOR conseil & ingénierie
> -----------------------------------------------------------
>
>
>

Have you tried this?
If your answer is no, please try it asap, and tell us whether you can transport a tablespace cross-platform.
I will bet the experiment will force you to blush of shame.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Wed Aug 22 2001 - 12:01:02 CDT