Hello . I have problem about syslob segment. there are 2 tables. And these tables situated in their own tablespace. every day script deleetes data from these tables . when I see data inside of tables there is only 5 gb data inside it. But then I looked at tablespace object there is big object with name of SYS_LOB00000000$$ (for example) SYSLOB segment 460 gb but data is only 5 gb how can I reslove it? Olease help me . I did shrink but almost 3 day is shrinking nothing happened. SHRINK script in blow
alter table schema.table modify lob (column) (shrink space)