Originally posted by TomazZ
or you can export the data with compress=y, drop the table and import the data
It's not really adviable to use the compress=y unless you are sure that the data content of the table is using all of the space currently allocated.

If you have a table which has allocated 200Mb of extents yet the data contained within the table is only 10Mb (due to deletes, etc) then the compress=y will build a table with a single 200Mb extent rather than a single 10Mb extent.

IMHO it is better to establish the storage requirement first.

REgards