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,