Looked and couldn't seem to find anything related to this so here goes. I have an object based on the ordsys.orddoc type and have a table that has columns based on this object. I have blobs stored in the column, but have moved them out to the o/s cause we had more space there than in the DB. To clear out the blob, I issued a call to the deletecontent method on the object which cleared the blob (made it's length 0). In the past, I would export the table after rows were deleted then truncated the table then imported it to reclaim space. Will this procedure achieve the same result when using the deletecontent method? I tried to do an estimate expdp but it said that the size was still as large as it was before the update. Any help would be greatly appreciated. Oracle version is 10.2.0.3.0.
expdp estimate=blocks = 77.41 GB
expdp estimate=statistics = 95.76 MB
Query the table asking for the sum of the size of the blob column 14.46 GB
Most of the updates were done in the last few days, table was last analyzed Jul 21, 2015 10:22:49 PM CDT
Message was edited by: Eric Schrauth