import done in US7ASCII character set and AL16UTF16 NCHAR character setSegmentation Fault (coredump)
Last week I migrated some schemas from 11g database (188.8.131.52) to 9i database (184.108.40.206).
I used to export the 11g schemas using oracle 9i binary & exported successfully.
While importing 11g schema’s into 9i database I faced below issues.
Error: import done in US7ASCII character set and AL16UTF16 NCHAR character setSegmentation Fault (coredump)
Operating system: Sun Solaris 10 / 64 bit processor
I exported the 11g schema’s using 10g binary and imported into 10g database
successfully. While import using 9i binary, I faced above issue.
Finally I tried below metalink notes. Its working fine.
Solution: (Metalink Note: 550740.1)
Problem occurs on any platform: Version: 220.127.116.11 to 18.104.22.168
You need to export data from 11g and import into 9iR2. For this reason, the exp utility version 9iR2 is used to extract data from 11g. There are two aspects of this
1. Connect to database 11g as SYSDBA with SQL*Plus
2. Change the definition of view EXU9DEFPSWITCHES from:
3. Re-start exp version 9iR2 to extract from 11g
4. Import the new dump using imp version 9iR2.
I Hope this article helped to you. Suggestions are welcome.