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: Howard J. Rogers <dba_at_hjrdba.com>
Date: Tue, 2 Jul 2002 10:38:56 +1000
Message-ID: <afqsp3$usa$1@lust.ihug.co.nz>

<vze3djdq_at_mail.verizon.net> wrote in message 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

I'm afraid I can't honestly say I understand a word of what you've written here.

All I can tell you is that If you are trying to export from an 8i database and import into a 9i one, then you must make sure you run the export using the 8i binaries on the 8i machine. That gets you an 8i export dump file. You can then run the 9i import binaries on the 9i machine, and reference the 8i dump file.

What I *think* you are doing (only it's so hard to tell the way you've explained this), is run export on the 9i machine connecting to the 8i database by connecting across the network with a tnsnames alias. That won't work: it means you'll be using the 9i executables, and the rule is that you can't run a higher version of export against a lower version of the database.

> 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
>

It doesn't help when you say you are running "imp" and get an "EXPort" error, does it?

If I've misunderstood what you've been doing, my apologies.

Regards
HJR
> Please advise ...
>
> Thanks,
> Henry
>
>
>
>
>
Received on Mon Jul 01 2002 - 19:38:56 CDT

Original text of this message

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