Re: export from oracle8i and import into oracle8.0.5

Never done it but I believe you can rerun the releveant CAT*.sql script from the target version (8.0) in the source database (ie 8i) and the export can be produced in the older format. You will need to check this out with people who have done it for details.

Regards

--
Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich England)

                        <KevinALewis_at_HotMail.com>

The views expressed herein by the author of this document are not necessarily those of BOCM PAULS Ltd. <michael_bialik_at_my-deja.com> wrote in message news:80comn$h39$1_at_nnrp1.deja.com...
> Hi.
>
> As far as I know :
> Oracle supports EXPORT from old version amd IMPORT to new one.
> It does NOT supports the reverse direction.
>
> Michael.
>
> In article <3829BF1D.4A67EDA6_at_net-dept.de>,
> Thomas Jork <tj_at_net-dept.de> wrote:
> > hi there
> >
> > i have a problem with an import, which is exported from an oracle 8i
> > enterprise server.
> > i want to import into oracle8 standard server. if i start the import
> > with a command like :
> > imp formuser=bla touser=foo file=exp01.dmp
> > oracle throws the follwing exception:
> > imp-0008 unrecognized statement in the export file
> >
> > i have never had any problems with import/export, so i'm really
> > wondering about that.
> >
> > thanks in advance
> >
> > thomas
> >
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Nov 11 1999 - 03:58:23 CST