Re: imp00069 error - help needed

Your NLS_LANG environment variable is

1. not set or
2. set to US7ASCII

If a) is true, import will set the value to b) automaticaly.

If the export was done in an 8-bit character set, importing using a 7-bit 'fiter' will force the loss of information, 1 bit for every byte.

If it can, Oracle will map as best as possible all 8bit characters to 7bit ones. Not that I agree with it trying to do this at all though.

Luckily for you, it has decided, for some other reason, not to let you squeeze the exported data through 'too narrow a pipe'.

If possible, find the character set of the database that was exported. Read up a bit on NLS parameters, and then set NLS_LANG to the appropriate one, just before you start the import.

D.P.

Jan Kucharski wrote:
>
> Hi,
>
> I have a dump of an 'unknown' database.
> Want to import it to my solaris system but am receiving this imp00069
> error.
>
> How can I find out which char set it was exported ?
>
> the log file of an error:
>
> Connected to: Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
> With the Partitioning and Java options
> PL/SQL Release 8.1.5.0.0 - Production
>
> Export file created by EXPORT:V08.01.07 via conventional path
>
> Warning: the objects were exported by SYSTEM, not by you
>
> import done in US7ASCII character set and US7ASCII NCHAR character set
> IMP-00069: Could not convert to environment national character set's
> handle
> IMP-00000: Import terminated unsuccessfully
>
> Any help is greatly appreciated,
>
> Jan
> jkucharski_at_altavista.net
Received on Fri Apr 27 2001 - 19:53:09 CDT