Cannot shrink SECUREFILE LOB columns.

[Mladen Gogala]

Well, it seems that the classic "shrink space" command doesn't work on
SECUREFILE LOB columns:

1* alter table moreover_documents shrink space cascade
SQL> /
alter table moreover_documents shrink space cascade
*
ERROR at line 1:
ORA-10635: Invalid segment or tablespace type

So, I checked the manual and here it is http://tinyurl.com/3rwmt8c:

************************************************************************
Shrink operations can be performed only on segments in locally managed
tablespaces with automatic segment space management (ASSM). Within an
ASSM tablespace, all segment types are eligible for online segment shrink
except these:

*

IOT mapping tables
*

Tables with rowid based materialized views
*

Tables with function-based indexes
*

SECUREFILE LOBs

*************************************************************************

So no shrinking space on the SECUREFILE LOB columns. If you need to
shrink space in those, the advanced compression option is the only
choice.
I will let the my LOB columns spend some more time as SECUREFILE LOB
columns and if the used space starts growing, I'll know where the problem
lies and will convert them back to the basicfile. I should have known by
now that Oracle will not give away a usable feature.

--
http://mgogala.byethost5.com