Re: How to shrink a table?

From: David Greensmith <david_at_green1.demon.co.uk>
Date: Sun, 09 Aug 1998 03:56:00 GMT
Message-ID: <35cd1da1.21280213@news.demon.co.uk>

"David Rueter" <drueter_at_assyst.com> wrote:

>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
>
>

If your table with the deleted rows consists of more than one extent, you could try copying its contents to a temporary table, truncating the original, and then copying the data back.

David
David Greensmith :-)
(david_at_green1.demon.co.uk) Received on Sat Aug 08 1998 - 22:56:00 CDT