Re: Update nls_length_semantics!

"Hans" <sorry_at_nospam.com> a écrit dans le message de news:coho9s$m0d$1_at_green.tninet.se...
> Hi!
>
> On a UTF-8 Oracle 9.2 database is it possible to change the
> NLS_LENGTH_SEMATICS from byte to char without having to recreate the table?
> We had the sematics set to byte and that means that in a varchar2(40) it can
> store 40 bytes but since some characters are two bytes or more you cannot
> insert 40 characters as we want.
>
> If it is not possible to change directly is the way to do this to export
> data, change the semantics, create our new tables and then import just the
> data from the export file?
>
> Regards
> /Hans
>
>

Did you try "alter table modify"?

Regards
Michel Cadot Received on Tue Nov 30 2004 - 11:32:20 CST