Re: How to import to 9i from 8.1.7?

"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

******************************************