Re: import/export problem

One point, catexp7.sql is in the Oracle8 rdbms/admin directory.

Andrew

Andrew Babb wrote:

> 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:20:28 CDT