While converting Clob column datatype to NClob datatype
i am getting following problem.
SQL> SELECT * FROM V$VERSION
2 /
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
SQL> desc Tab1;
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
P_KEY NOT NULL NUMBER
TABLE_TEXT NOT NULL CLOB
SQL> alter tab1 TABLE_TEXT modify note_text nclob;
alter table j_note modify note_text nclob
*
ERROR at line 1:
ORA-22859: invalid modification of columns
Anybody know how to change the clob --> Nclob datatype
without using the temp column usage..
Regards
Singh