This discussion is archived
2 Replies Latest reply: Dec 10, 2012 8:45 AM by SID3 RSS

NCLOB to CLOB conversion

SID3 Newbie
Currently Being Moderated
Hi,

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?

Kindly suggest.

My DB Version is Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points