Lob And Clob Files

Sebastian Larsson

Sebastian Larsson

New Member
Hello Friends,

I need your help, how to move LOB or CLOB files no DATA to another area. Dont use dump to its a big critical database and not stay offline for more than 1 hour.
"Tablemove" move all the files (LOB + CLOB + DATA). I need separate.
Database size = 142 GB
I dont know this size of LOB + CLOB files.
In a practice to binary dump the process has taken more than 7 hours. only dump im not imaginate the drop.
Thanks for your help
 
It would be really helpful to know what Progress version you are on, and OS actually as well. There have been some major improvements to the efficiency of the dump and load process in more recent releases.
 
Seems like binary D&L couldn't load LOB into a different area number than it was dumped from in 10.x That might have been fixed in later versions. I believe we renamed the original table, created the new table with LOB data going to a separate area and then used raw transfer to move the data over.
 
Thanks,

1) This version is Progress Open Edge 10.1 Service Pack 4 RDBMS and Replication.
2) OS is AIX v 6.1
3) I tried binary dump using a small index and -RO and load and took more than 7 hours.
This size of area is 65 GB aprox.
4) Well im not receive errores, the process finish ok but its very slow, only need move the files (lob + clob) no the data, i dont know by for each, i dont know.

Thanks for your help.
 
LOB's are a bit of an after-thought.

There is no "LOB Move" utility.

You might want to try something along the lines of what CJ suggests. Or create a new table for the LOB and put it in a proper storage area then write a program to copy the LOBs from one table to the other. Depending on your application and the code you could perhaps set a flag in the source record to indicate a LOB that has been moved. Or maybe you can copy them all and then tweak the code to look in the new location. The possibilities are endless!
 
Lastly (for now)....

10.1 is ancient, obsolete and unsupported. The very last release of OpenEdge 10 is 10.2B which is now 6 years old. OpenEdge 10 will never again be patched or enhanced and will become increasingly unsupportable and a security hazard. Your auditors will write you up in an increasingly stern manner. Progress upgrades are free, simple and easy. And they save you money because maintenance is cheaper when you stay on a current release. You should upgrade immediately.
 
You must log in or register to reply here.
Back
Top