Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: database defragmentation :)

Re: database defragmentation :)

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 04 Apr 2007 07:49:01 GMT
Message-ID: <1175672940.590385@proxy.dienste.wien.at>


Joe <joe1977_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 Received on Wed Apr 04 2007 - 02:49:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US