-
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
-
unless u willn't delete the duplicate rows u can't enable the primary keys.
Check the local nls_settings before export and import.
-
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
-
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|