Oracle Import error - enterprise to standard db
Posted on 2012-03-30
We're downsizing from enterprise to standard because of licensing reasons.
When I do an import, i get:
. . importing table "TTICPR951101"
IMP-00020: long column too large for column buffer size (22)
IMP-00028: partial import of previous table rolled back: 858363 rows rolled back
At the top of the import, I noticed that the charsets are not quite the same:
Connected to: Oracle9i Release 220.127.116.11.0 - 64bit Production
JServer Release 18.104.22.168.0 - Production
Export file created by EXPORT:V09.02.00 via direct path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
export server uses UTF8 NCHAR character set (possible ncharset conversion)
1- Is the import problem related to the message "possible ncharset conversion" ?
2- Maybe a bad export via direct and unix compress .Z ?
3- How do I create a standard edition database that is exactly the same as my enterprise edition database so that when I import I will have the same charset, lang on both ends ?
I thank You in advance since this is driving me over the brink :-) and your help is greatly appreciated.