Hello community,
I have a partitioned table on a RAC Database 12c in ASM that has a HUGE amount of BLOB files (about 3TB).
I had to cancel a good chunk of these BLOB files due to space management. Now I need to reclaim that space.
I tried this command:
alter table <table_name> MODIFY partition <partition_name> shrink space
And got this error:
ORA-10631: SHRINK clause should not be specified for this object
Also tried:
alter table <table_name> MODIFY LOB (<blob_column>) (SHRINK SPACE)
and got this error:
ORA-10635: Invalid segment or tablespace type
Any hint on what am I doing wrong? (there are no function based indexes on the table)
Thank you
Phelit