Re: Export database from 8.1.7 to 8.0.6

"Gabriel Gonzalez" <none_at_none.com> wrote in message news:nbll9v0p4argedilo083jpe6ilomiqrujg_at_4ax.com...
> What you are trying to do is wrong. You cannot run exp/imp against a
> different version of the database, unless you recreate the export
> helper objects in the database.
>
> In other words you have to run the 806 version of catexp.sql against
> your 817 version of the database. That is fair enough, but be aware
> that if you do this, then your 817 version of exp/imp will fail to
> work until you run the 817 version of catexp.sql againt the database.
>
> So make things easier for yourself and run the 817 version of exp/imp
> vs the 817 version fo the database. On the other side, run the 806
> version of the emp/imp against the 806 database. If the versions
> match, then you are almost there.
>
> I do not think it should be a problem exporting on 817 and importing
> into 806 (it sounds as though that is what you want to do). I have
> done those "downgrade" exports successfully before.
>

This is about as wrong as you can get. The rule is: you use the lower version of the executables against the higher version of the database, thereby producing a lower-version dump file. Which is precisely what the original poster did. And there is no catexp806 to be run, either.

The original poster has done everything correctly.

His problem is that various triggers and sequences are not imported. And my guess would be that they were created by SYS. Nothing SYS creates ever gets exported. And therein lies one of the major 'problems' with export.

Regards
HJR Received on Mon Apr 14 2003 - 14:37:30 CDT