Problem while importing from UTF8 to UTF8!!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Problem while importing from UTF8 to UTF8!!

  1. #1
    Join Date
    Feb 2002
    Posts
    70

    Problem while importing from UTF8 to UTF8!!

    Hi All,
    While trying to import data from UTF8 database schema to another UTF8 database schema, data is getting inserted but when trying to enable the Unique key's or Primary key its throwing an error ORA-01452 (Duplicate keys found), ORA-02299 and ORA-02270 - Can not validate Unique keys.

    Oracle Version is : 8.1.7
    OS - Sun Solaris
    Database Character Set is : UTF8
    NLS Character Set is : UTF8.

    One more thing I observed while exporting, the schema is getting exported in US7ASCII and UTF8 National Character Set.

    Also while importing it is getting imported as
    "import done in US7ASCII character set and UTF8 NCHAR character set"

    Any help in this is highly appreciated.

    Thanks,
    ________________
    ShanDJ

  2. #2
    Join Date
    May 2001
    Posts
    736
    unless u willn't delete the duplicate rows u can't enable the primary keys.
    Check the local nls_settings before export and import.

  3. #3
    Join Date
    Feb 2002
    Posts
    70
    Hi Akhadar,
    Thanks for your response. But my problem is the schema that is exported doesn't contain any duplicate rows. While I am importing it into new schema (no data contains) its giving an error that duplicate records found while enabling the constraints. Both the databases are of UTF8 format.

    Thanks,
    ________________
    ShanDJ

  4. #4
    Join Date
    May 2001
    Posts
    736

  5. #5
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    Looks, like you are exporting UTF8 into US7ASCII.
    Here you may lose some information, becuse US7ASCII character set is very narrow and there is number of character that cannot be adequately converted from UTF8 to US7ASCII.
    You should set environment (nls_lang) to unicode also and then exp/imp.
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

  6. #6
    Join Date
    Feb 2002
    Posts
    70
    Thanks Tomazz. You are right, I have checked the character set in which it is exporting. I set the NLS_LANG before export and while importing. Its work fine.

    Thanks,
    ________________
    ShanDJ

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width