Import error - IMP - 00069

[cca]

Hello,
Am trying to import an .dmp file exported from Oracle 8.1.7 to another database, version 8.1.6. But i get the error message below.

Export file created by EXPORT:V08.01.07 via conventional path
import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
IMP-00069: Could not convert to environment national character set's handle
IMP-00000: Import terminated unsuccessfully

Pls what can i do to carry out a successful import

[bazza]

And what did metalink say when you looked up the error?

[cca]

Oracle Documentation says contact oracle support

[davey23uk]

Originally posted by cca
Hello,
Am trying to import an .dmp file exported from Oracle 8.1.7 to another database, version 8.1.6. But i get the error message below.

Export file created by EXPORT:V08.01.07 via conventional path
import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
IMP-00069: Could not convert to environment national character set's handle
IMP-00000: Import terminated unsuccessfully

Pls what can i do to carry out a successful import

did you do the export with 8.1.7 exp - if so you cant do that. Look at metalink note 1019280.102

[cca]

Yes the export was done with 8.1.7 exp. pls can you give me url to metalink

[davey23uk]

Originally posted by cca
Yes the export was done with 8.1.7 exp. pls can you give me url to metalink

You can do that yourself!, go to search and put that note in.

But I know your problem, you cant use 8.1.7 exp and then use it in 8.1.6. You will have to use the 8.1.6 exp on the 8.1.7 database

[cca]

I have exported using 8.1.6. But not all my data is imported. I get warnings about existing objects

[davey23uk]

Originally posted by cca
I have exported using 8.1.6. But not all my data is imported. I get warnings about existing objects

what imp command did you use - did you specify ignore=y?

[cca]

I used ignore = N

[davey23uk]

Originally posted by cca
I used ignore = N

then why the surprise when you get errors when objects already exist?