Re: How to shrink a table?

Rather than adding another file you can resize the datafile. here is the way to do it:

alter database datafile '/r1/xyz/abc.dbf' resize 500M;

Regards !!!

Alfons Riesebeek <A.Riesebeek_at_wxs.nl> wrote in article <6pp4gl$mje$1_at_hdxf08.telecom.ptt.nl>...
> 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 - 09:04:20 CDT