update clob column with varchar column
Posted on 2010-08-12
I added a new column to the existing table (clob column) and i wanted to move the existing data from varchar column to the newly added clob column. ( The size for the existing varchar is not enough and I don't want to remove that column so i didn't do alter table to change the data type)
UPDATE schedule_ table
SET condition_large_sql = to_clob(condition_sql);
This statement is running for ever.
The table has 360 records.
UPDATE STATEMENT ALL_ROWSCost: 3 Bytes: 292 Cardinality: 4
2 UPDATE SCHEDULE_TABLE
1 TABLE ACCESS FULL TABLE NEMA.CR_REPORT_SCHEDULE Cost: 3 Bytes: 292 Cardinality: 4