Thanks for the question, chandrasekhar.
Asked: October 01, 2018 - 1:54 pm UTC
Last updated: October 03, 2018 - 4:33 am UTC
Version: 12.1.0.2.0
Viewed 1000+ times
You Asked
Hi Tom,
I have two tables which have clob data, Trying to merge the clob data from work table to Live table. its taking more and more days.. total data size 72GB.
What is the best way to run the merge in this case to complete the task quickly.
Please help me.
Regards
Chandra.
and Connor said...
Trace it - see where the time is being lost.
You didn't give us:
- any DDL
- any commands you were running
- any information about hardware being used
- typical size of clobs
- MERGE being the merge command? or merging multiple tables? or merging partitions? or something else
So I don't really know how we can help you much more than saying trace it and work from there.
Is this answer out of date? If it is, please let us know via a Comment