Oracle Import error - enterprise to standard db

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 9.2.0.6.0 - 64bit Production
JServer Release 9.2.0.6.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.

Bruno
MTL999Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MTL999Author Commented:
Export done in US7ASCII character set and UTF8 NCHAR character set
0
slightwv (䄆 Netminder) Commented:
>>How do I create a standard edition database that is exactly the same as my enterprise edition

Create it with the same character sets?

You might be able to migrte as long as the new character set is a subset of the new one.

Check out the NLS_LANG environment variable.


Does the old database have a Function Based Index?

There is a great thread for this error at:
http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:1011831135205
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.