Hi..We have a table. Which has 4 columns.
1.ID column,2.CLOB column(which contains file information),3.Create Date,4.Create BY.
Inserting data in this row is increasing exponenetially. Currently the size of this table is 400GB. Now to manage this table we have decided to delete some data in every year. But as deleting doesn't free up the space for CLOB table we need to shrink it. My question is is there any way that after every deletion we don't have to shrink/compress the table to free up the space.