Re: Export database from 8.1.7 to 8.0.6

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.

>Hi there.
>
>I have a produktion database running on oracle 8.1.7 and I now need the
>structure of this database (everything except the data) to be transfered
>to one test environment.
>
>I need to export 3 schemas. I use the 8.0.6 exp80 utility and connect to
>the production 8.1.7 and export the 3 users (I start exp80 without any
>options so it prompts me for its parameters like filename which users
>etc). Then I try to use the 8.0.6 imp80 to import it to the test env
>running 8.0.6. The 3 users do exists. Tablespaces with same names also.
>Actually there is an older version of the application with all its
>tables and data on it. When I use the imp it get tonns of errors. I
>tried to drop a schema and recreate it before running imp so I only have
>the new data. I get tables and other data, but some/all triggers,
>sequences are missing. Why is that? Is my procedure wrong?
>
>I use the user sys to connect with the exp / imp utils.
>
>Error msg mostly that a grant has failed becaus the table does not
>exists. Arent the create tables executed before the grants?
>
>And are roles also exported / imported? Or how should I do this task?
>
>thanks for any hints.
Received on Mon Apr 14 2003 - 10:40:42 CDT