Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Export database from 8.1.7 to 8.0.6

Export database from 8.1.7 to 8.0.6

From: Marc Eggenberger <marc.eggenberger_at_itc.alstom.com>
Date: Mon, 14 Apr 2003 15:06:05 +0200
Message-ID: <MPG.1904d0aaa943f6d3989695@localhost>


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
Received on Mon Apr 14 2003 - 08:06:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US