Re: Export Error during 817 to 805 table export

"Antoine BRUNEL" <antoinebrunel/yahoo.fr> wrote in message news:3ec6cd40$0$27274$79c14f64_at_nan-newsreader-01.noos.net...
> hi from Paris
>
> it is not a good idea to export date with a different version of EXP
binary
> compared to Oracle RDBMS.
>
> You should bettter export with 8.0 'exp' program, then import it with 8i
> 'import' prog.
>
>
> PS: what I said is the SUPPORTED AND WORKING way. RTFM !!!!!!!!!!

Actually, it's incorrect. The original poster is trying to get data out of an 8.1.7 database into an 8.0 database. Using the 8.0 version of the executable against the 8.1 database is the correct way to do that.

And what you suggest will definitely not work, as the 8.1 version of import will likely throw a complete wobbly when it encounters the older version dump file produced by your suggestion of using 8.0 export.

Having written a paper on what version of export works with what version of import from version 7.0 upwards, I happen to know this (though it wouldn't take much to work it out, given the number of times advice directly opposite to yours has been posted on this group, by Sybrand, Daniel and others).

Regards
HJR
>
>
>
> "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> a écrit dans le message de
> news:35Vwa.35103$1s1.509696_at_newsfeeds.bigpond.com...
> >
> > "DOKNIK" <dominiqs_at_o2.co.uk> wrote in message
> > news:1053013304.723893_at_ernani.logica.co.uk...
> > All,
> > I have used an Oracle 8.0.5 version of EXP ie(
> > /u01/app/oracle/product/8.0.5/bin/exp) to do a table export from a
> > database on Oracle 8.1.7 to an Oracle (8.0.5) database
> > but during the export i get the errors below.
> >
> > About to export specified tables via Conventional Path ...
> > . . exporting table BV_SHOP_LARGE_CONTENT
> > EXP-00008: ORACLE error 904 encountered
> > ORA-00904: invalid column name
> > Export terminated successfully with warnings.
> >
> >
> > Using suggesstions from Metalink i tried the following
> >
> > 1.I run catexp.sql as SYS
> > 2.run initjvmaux.sql
> > 3.run rmjvm.sql
> >
> >
> > These were the steps suggested at metalink but still doesnt work.
> > I am running this on Solaris 2.6
> >
> > Any ideas will be welcome.Thanks
> >
> > ===========
> > First idea: don't post in HTML, because a lot of regulars here don't use
> > Outlook Express, and can only see plain text messages.
> >
> > Second. Do a desc of BV_SHOP_LARGE_CONTENT, and post the results here.
> >
> > Regards
> > HJR
> >
> >
> >
>
>
Received on Sat May 17 2003 - 21:58:11 CDT