I have a requirement to convert few columns of a table from NCLOB to CLOB. I used the below mentioned steps
1) Renamed the the original table and all its dependent object.
2) Created the the table with same structure and required CLOB columns. These columns were NCLOB previously.
Now i want to move data from the renamed table to the new table. My question is
Will a norma insert statement like
"Insert into original_table_name select * from renamed_table_name;" will work ?
or i will have to use something like
"Insert into original_table_name select (col1...to_clob(col_nclob)...coln) from renamed_table_name;" will work?
My DB Version is Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production