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: Henry Kam <kam1_at_whwpe.lucent.com>
Date: Tue, 02 Jul 2002 15:49:07 GMT
Message-ID: <3D21CB2F.9CA687CE@whwpe.lucent.com>


Thank for the info.....

I mistyped the "imp" in my post, it should be "exp" as can be seen from the error message...

Thanks again
Henry

Niall Litchfield wrote:

> "Henry Kam" <kam1_at_whwpe.lucent.com> wrote in message
> news:3D21BF41.77668E60_at_whwpe.lucent.com...
> > 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
>
> This is the underlying problem. The explanation of the error in the docs is
> fairly self explanatory
>
> IMP-00016 required character set conversion (type number to number) not
> supported
>
> Cause: Import could not convert the character format of the export file into
> the native character format.
>
> Action: Change the user character set by setting the NLS_LANG environment
> variable to match the character set of the export file.
>
> > 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
>
> Here you are running imp from 9i against an 817 db. This is what Howard said
> (correctly) won't work.
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
Received on Tue Jul 02 2002 - 10:49:07 CDT

Original text of this message

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