Re: import/export problem

Thanks Andrew

That appears to have resolved the problem

Cheers
Pete
Andrew Babb <andrewb_at_mail.com> wrote in message news:370C9F0C.2323FA2_at_mail.com...
> 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 Fri Apr 09 1999 - 03:32:30 CDT