Re: Export Oracle low version?

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Sat, 20 Jul 2002 19:53:15 +0100
Message-ID: <3d39c17e_2@mk-nntp-1.news.uk.worldonline.com>

"Mark D Powell" <mark.powell_at_eds.com> wrote in message news:178d2795.0207190556.5390fac3_at_posting.google.com...
> hackwake_at_yahoo.com (wahe) wrote in message
news:<4d236098.0207190302.35d9cdeb_at_posting.google.com>...
> > Like the tablas of the Oracle exports version 8.1.7.0.0 to a low
> > version, for example 8.1.6.0.0?
> >
> > I have tried with the exp but it does not stop me working
> >
> >
> > Hackwake
> >
> > http://nomeenteronaa.cjb.net
>
> Hackwake, I am not sure I understand your post but in general if you
> need to copy data using exp/imp from a newer version of Oracle to an
> older version you use the exp utility of the older version to export
> from the newer version and then import using the matching version.
>
> HTH -- Mark D Powell --

Correct. And before doing so, you usually have to run a script on the newer version, which will create a set of views to support the earlier version of exp.

HTH,
Paul Received on Sat Jul 20 2002 - 13:53:15 CDT