Re: How to import to 9i from 8.1.7?

Howard,
Sorry about the confusion (Error in my typing....)

I did an export (b.dmp) from Machine B in which o8i was installed and transferred b.dmp to Machine A in which o9iR1 was installed( Two database were in
different character sets)...

Then in Machine A: ORACLE_HOME & ORACLE_SID were set

            imp userid=system/manager show=y file=b.dmp
           terminates with error:

IMP-00016: required character set conversion (type 31 to 871) not supported IMP-00000: Import terminated unsuccessfully

Trying to overcome the above errro, I then issued the command " imp userid=system/manager_at_orcl "  from Machine A (o9iR1) thru network
after modifying hosts/tnsnames.ora and got the following error:

 Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Productio

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

"Howard J. Rogers" wrote:

> <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 Tue Jul 02 2002 - 09:58:14 CDT