Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Export database from 8.1.7 to 8.0.6
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 EggenbergerReceived on Mon Apr 14 2003 - 08:06:05 CDT
![]() |
![]() |