|
gor
Retired Admin
Netherlands
5511 Posts |
 Posted - 09 March 2001 : 19:07:24
|
In the Oracle documentation I read something about Trimming a CLOB because it doesn't shrink automatically and something about not being able to actually delete the CLOB itself.
So am I correct in assuming that I need to:
1) TRIM() the CLOB after each UPDATE just to make sure it has the minimum lenght needed.
2) SET the CLOB the EMPTY first before deleting the record that references that CLOB ?
What would happen if I didn't do 2) ? Would the CLOB still be there and just use diskspace without me being able to get rid of it ? Does Oracle clean it up for me ?
Pierre< |
|
Forum Locked
