sorry yes. the downwards restriction applies to both exp and imp.
--
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
******************************************
"Henry Kam" <kam1_at_whwpe.lucent.com> wrote in message
news:3D21CB2F.9CA687CE_at_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 Wed Jul 03 2002 - 03:41:59 CDT
