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 -> import/export problem

import/export problem

From: pb <peter.bruton_at_intactix.co.uk>
Date: Thu, 8 Apr 1999 12:05:12 +0100
Message-ID: <370c8d80.0@nnrp1.news.uk.psi.net>


We recently had a crash on an Oracle 7 (ora7) server and have been rebuilding my system. Luckily before the server crashed we exported the designer repository, so while I was rebuilding the 7 server I was asked to import the repository onto an Oracle 8 (ora8) server so that we could continue our work This all worked OK.

Now I've got my ora7 server to a reasonable state, I want to put the repository back.
If I export the repository from ora8 using exp80, I cannot import it into ora7 using imp80 because I get the following error:

     Import: Release 8.0.5.0.0 - Production on Thu Apr 8 11:15:30 1999
     (c) Copyright 1998 Oracle Corporation.  All rights reserved.

     Username: xyz/xyz_at_repo7

     Connected to: Oracle7 Server Release 7.3.4.0.0 - Production
     With the distributed, replication and parallel query options
     PL/SQL Release 2.3.4.0.0 - Production

     IMP-00003: ORACLE error 942 encountered
     ORA-00942: table or view does not exist
     IMP-00023: Import views not installed, please notify your DBA
     IMP-00000: Import terminated unsuccessfully


I've also tried exporting the ora8 repository from the ora7 server using exp73, but I get the following error:

     Export: Release 7.3.4.0.0 - Production on Thu Apr 08 11:10:02 1999
     Copyright (c) Oracle Corporation 1979, 1996.  All rights reserved.

     Username: xyz/xyz_at_repo8

     EXP-00008: ORACLE error 942 encountered
     ORA-00942: table or view does not exist
     EXP-00024: Export views not installed, please notify your DBA
     EXP-00000: Export terminated unsuccessfully


The userid I'm using is SYS or an equivalent I've looked up the error messages but I'm still stuck. I've also run CATALOG.SQL (or CATEXP.SQL) on the ora7 server as advised in the manual, but still no luck.

Am I attempting something impossible? I've been told that it should work OK.
Can anyone help?

Thanks
Pete Received on Thu Apr 08 1999 - 06:05:12 CDT

Original text of this message

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