Monday, March 11, 2013

IMP-00037: Character set marker unknown

                   IMP-00037: Character set marker unknown


Today while i was doing a migration from a 9i database 11g R2 database i received the error  IMP-00037 : Character Set marker unknown and the import terminated .

Here is how i rectified the issue .

SOURCE BOX : AIX 

TARGET BOX : Linux 

This issue usually arises  when the dump is corrupted .

In my case the it wasn't the corruption. 

To reduce the file size the dump file is compressed by the Unix COMPRESS utility .

In the Linux server (target) i did not un-compress  it , so the import failed . 

To resolve this i used the GUNZIP Linux utility and the re-imported the data and it completed successfully .


2 comments:

  1. Why is my casino'safe' to play at the table? - Dr.MCD
    I'd like to 경주 출장샵 share my experience with you 구미 출장안마 a little bit. If you can't 전주 출장마사지 decide between a blackjack table 여수 출장마사지 or a 부천 출장샵 casino table, do we help you become a

    ReplyDelete