Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> import/export problem
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
![]() |
![]() |