LOB's and tablespace
Posted on 2004-09-17
some applications safe some data into some tables. one table use 'CLOB' as datatype.
after some time i will manually delete the records (delete from table xxx;commit;)
but: i cannot get free tablespace (tablespace that used by 'LOB' are full)
i am thinking of reorganisation of the used tables, but are there other options available?
the 'CLOB' use very much tablespace too!! are there options to safe some data (messages) more effective?