Re: Export database from 8.1.7 to 8.0.6

Originally posted by Marc Eggenberger
> 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.
>
> --
> mfg
> Marc Eggenberger

Please post the error messages that don't relate to grants. If the table doesn't exist, there must be a reason why. We need to see those errors to be able to help.

HTH,
Patrick

--
Posted via http://dbforums.com