How to shrink a table?

I have an Oracle 7 tablespace that is nearly full.

Rather than adding a file to the tablespace, I have deleted some unneeded rows from some tables.

However, the sizes of the tables do not change when I delete the rows.

I guess tables grow automatically, but don't automatically shrink. Is this right?

In any case, how can I reduce the size of (shrink) individual tables?

David Rueter
drueter_at_assyst.com Received on Thu Jul 30 1998 - 00:02:21 CDT