2 Replies Latest reply: Dec 19, 2012 8:07 AM by ursusca RSS

    insert into <table_xmltype> select * from <table_clob>

    ursusca
      Oracle 11.2. on Linux x64


      Hi All,

      I'm a DBA and don't have any xml experience. I have a table with xml stored as clob and would like to migrate clob to xmltype. I've created new table with xmltype column. How can I insert data into new table from the table with xml stored as clob? I've tried Data Pump with content=data_only option and got ORA-600 [qmcxdGetTextXYZ] error when I tried to select the table after import.

      Any help would be appreciated. Thanks,

      Edited by: ursusca on Dec 18, 2012 3:17 PM

      Edited by: ursusca on Dec 18, 2012 3:22 PM