This content has been marked as final. Show 3 replies
Unlike 10g XE 11g XE is available as Unicode characterset database only:
So now i have to do an IMPORT of a dmp file with tables only without data.
Then go alter all the tables to bigger size with varchar2 and then import the dmp file with the data, correct?
Yes, one way would be to pre-create tables using character semantics. E.g. table(column varchar2(100 char)) to state character semantics explicitly for character columns.
XE docs mentions this in a few places, about Length semantics. There's more if you search the full doc library: example search.
Edited by: orafad on Feb 26, 2012 10:38 PM