Re: database defragmentation :)

On Apr 4, 10:41 am, "Joe" <joe1..._at_tlen.pl> wrote:
> On Apr 4, 2:49 am, Laurenz Albe <inv..._at_spam.to.invalid> wrote:
>
> > Joe <joe1..._at_tlen.pl> wrote:
> > > hi. I've just dropped table (approx 70mb) from our tablesystem by
> > > truncate, however dump file still keeps "old" file size. Is there any
> > > oracle optimizer or defragmation tool (hehe) that if one truncate big
> > > chunk of data, you can run it to get all the bits and bytes better
> > > organized?
>
> > You didn't say what version you use, but if it is 10g, purging the
> > recycle bin might help.
>
> > Yours,
> > Laurenz Albe
>
> its 10g. I did purge rec bin. Laurenz - this was simply old log table
> - it was fullfilled with data. after truncate, exp file should be 70m
> less.

How did you purge the recycle bin? Depending on the command you used and what username you used and what username the objects belonged to you may not have purged the large table.

Example:
purge recyclebin <- only purges objects owned by the current user
purge dba_recyclebin <- purges everything

HTH -- Mark D Powell -- Received on Wed Apr 04 2007 - 18:10:57 CDT