Be urgent!!!!!! I ask you, there is now a situation is oracle database table space have no disk space to expand, table space fill the object being two LOB, the two LOB object is from the same table of the two fields, how to clear up these two LOB object? Thank you very much!!!!!!

CodePudding user response:

If LOB field itself has very big, is unable to clean up, unless the historical data of clean up the table,
If LOB field exists to pieces, can SHRINK or compression, the reference "the SHRINK SPACE: online contract table, LOB, IOT section size"