Re: Releasing space after deleting lobs

Other than export, truncate (or drop) and import, try

alter table mytab lob (mylobcol) store as ...

Check the syntax in SQL manual.

Make sure you rebuild unusable indexes after table move.

Yong Huang
yong321_at_yahoo.com

"P. Bartkiewicz" <filix_at_poczta.gazeta.pl> wrote in message news:<a5ks1h$qgu$1_at_news.tpi.pl>...
> The problem looks like this:
> I have a table with a lob column. The table and lob are placed in separate
> tablespaces. After deleting some about 50.000 records I was able to insert
> only 10.000 new records. Then I had to add a new datafile. Does anyone know
> something about mechanism of releasing space for lobs after delete?
Received on Thu Feb 28 2002 - 11:55:02 CST