Re: How to import to 9i from 8.1.7?

Do you remember which sql scripts in rdbms/adim need to be run?

The version of my o9iR1 is
Oracle 9i Enterprise Edition Release 9.0.1.1.1 - Production With the Partition option
Jserver Release 9.0.1.1.1 - Production

Thanks in advance..

Ban Spam wrote:

> vze3djdq_at_mail.verizon.net wrote in news:3D20ED87.F7EE63F0_at_mail.verizon.net:
>
> > Hello,
> >
> > I have two machines A(9i R1 with SID=tst1 on W2000) and B(8i 817 with
> > SID=orcl on NT) with different character sets..
> >
> > imp in A(9i) with exp from B(8i) terminated with error;
> >
> > After addingt machine B in /etc/system32/driver/etc/hosts and
> > modifying tnsnames.ora, I was able to execute from A
> > sqlplus system/manager_at_orcl to access 8i in B;
> > but
> > imp userid=system/manager_at_orcl terminated with the following error:
> >
> > Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
> >
> > With the Partitioning option
> > JServer Release 8.1.7.0.0 - Production
> > EXP-00056: ORACLE error 942 encountered
> > ORA-00942: table or view does not exist
> > EXP-00000: Export terminated unsuccessfully
> >
> > Please advise ...
> >
> > Thanks,
> > Henry
> >
>
> I stepped onto this landmine just last week.
> The problem is within the 9i instance.
> An extensive search of MetaLink revealed that
> I needed to (re)run some Oracle supplied SQL scripts
> which do things like REALLY install JAVA & such.
> I was able to import in less than 1 hour.
>
> HTH & YMMV
> dba at mwh dot com
Received on Tue Jul 02 2002 - 10:02:58 CDT