Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: database defragmentation :)
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. Received on Wed Apr 04 2007 - 09:41:10 CDT