Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to import to 9i from 8.1.7?
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 Mon Jul 01 2002 - 19:22:28 CDT