vishali_vishu
asked on
update clob column with varchar column
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);
commit;
This statement is running for ever.
The table has 360 records.
Plan
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
UPDATE schedule_ table
SET condition_large_sql = to_clob(condition_sql);
commit;
This statement is running for ever.
The table has 360 records.
Plan
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
ASKER
it is running forever.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
UPDATE schedule_ table
SET condition_large_sql = condition_sql;