Re: import/export problem

PB,

I think you will find a script catexp7.sql which is run against the Oracle8 instance, but you use Oracle7's EXP utility to complete the export. Then this can be imported into the Oracle7 instance without any further problems. (That's the theory anyway :-)

Andrew

pb wrote:

> 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 - 07:17:51 CDT