What is the preferred method to shrink a table that contains a LONG Datatype? I can not change the data type due to the third party software application. I need to find a way to shrink these tables.
Would it benefit to have all tables with LONG's in them in a separate table space. Tables range in size from 50 rows to 4mm rows.
Version is 10.2.0.2 on Linux