Re: Xfer dbase from UNIX to Win '95

The other way is to alter database backup control file either to the trace or to a file and use it to rebuild the base database. After that a full exp and import will usually do the trick.

Craig M. Wall <cwall_at_petersons.com> wrote in article <6juk77$ecu_at_news9.noc.netcom.net>...
> Brad,
>
> Don't edit the export file.
>
> Simply pre-create the tablespaces with the correct sizes and DOS
filenames.
>
> Then run the import using the ignore=y parameter.
>
> Import will see that the tablespaces it has instructions to build are
> already there and will not attempt to create them, but it will use them
to
> store the objects.
>
> If you ftp'd the export file to windows make sure it was a binary
transfer.
>
> Craig M. Wall
>
> Brad Rad wrote in message <01bd83e8$20c562a0$31590acb_at_home>...
> >HI,
> >
> >I am trying to get an ORACLE 7.3.2 dbase off a UNIX server into Personal
> >ORACLE 8 on Windows '95.
> >
> >I have tried export/import thus far but the create tablespace statements
in
> >the dmp file have the explicit UNIX paths in them.
> >
> >Short of editing the dmp file, does anyone have any suggestion ?
> >
> >Also, re editing, in the morning I will try with sed as the dmp file is
too
> >long for vi. Any suggestions here ?
> >
> >Thanks,
> >
> >Brad.
> >
> >rad_at_OnTheNet.com.au
>
>
>
Received on Thu May 21 1998 - 20:06:52 CEST