Re: Export Error during 817 to 805 table export

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 !!!!!!!!!!

"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 - 19:01:04 CDT