2 Replies Latest reply: Dec 10, 2012 10:45 AM by SID3 RSS

    NCLOB to CLOB conversion

    SID3
      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