Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to import to 9i from 8.1.7?

Re: How to import to 9i from 8.1.7?

From: Ban Spam <ban-spam_at_operamail.com>
Date: Tue, 02 Jul 2002 00:22:28 GMT
Message-ID: <Xns923EB0BFB838FSunnySD@68.6.19.6>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US