How to import to 9i from 8.1.7?

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 Received on Mon Jul 01 2002 - 19:03:25 CDT