Re: exp sun & imp win

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Tue, 27 May 2003 20:18:03 +0100
Message-ID: <3ed3ca92$1_2@mk-nntp-1.news.uk.worldonline.com>

"Jack Silvey" <depifster_at_yahoo.com> wrote in message news:25c7944d.0305261610.8bd8ee4_at_posting.google.com...
> Sergio,
>
> Make sure your FTP is set to binary

Well, that much is true, but I'm not so sure about the rest.

The export file isn't 'text and binary'. It is binary, and needs to be copied 'as is'.

Different versions are fine. Exporting from a lower version to a higher version: no issues.
Exporting from a higher version to a lower version may need a set of views created (script is catexpvvv.sql in source), and the export created with the exp executable from the lower version. Again, depends on version. This is all well documented.

To OP: Yes, this is the way to go. This is precisely why Oracle invented exp and imp.

Regards,
Paul Received on Tue May 27 2003 - 14:18:03 CDT