How to copy a 110GB table with BLOBs from one schema to another on ORACLE
- by simao
Hello,
I have a table containing 110GB in BLOBs in one schema and I want to copy it to another schema to a different table.
I only want to copy a column of the source table so I am using an UPDATE statment, but it takes 2,5 hours to copy 3 GB of data.
Is there a faster way to do this?
Thank you