Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

nvarchar[max] conversion

488266Jan 6 2009 — edited Jan 26 2009
Hello all.
i am trying to convert an sql server 2005 into oracle 10g using sqldeveloper 1.5.
a table in sqlserver having nvacharmax column - supposed to be migrated into clob (according to the data map).
how ever when i look at the script for creating the oracle objects, I see those columns written as nvarchar2(0) - which obviously can not be .
if I run the conversion using nvachar2(size) - some data "fails" because the it is to long for varchar2 column .
if i set the table to be created with clob - all data being migrated but i see "bad" data .like(question marks etc') .
so . is it a bug in sqldeveloper ? am i doing something wrong ?

thanks

S.

p.s.
I have posted this question in SQLDEVELOPER forum as well, but I guess this is more suitable forum .
so apologies for those who saw this thread at the other forum as well.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 23 2009
Added on Jan 6 2009
6 comments
8,015 views