Re: How to shrink a table?

You can do and export and import from that table. The table will than be created in one initial extent.

I have seen OLTP databases shrink that way over 40 %.

Take care that the intial extent isn't larger then: Select max(bytes) from dba_free_space where tablespace_name='<tablepsace_name>';

If this is the case you must edit the export file.

Regards
Alfons

"David Rueter" <drueter_at_assyst.com> schrijfbewerkingen: > 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 - 01:40:21 CDT