Re: database defragmentation :)

On Apr 3, 6:49 am, "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?

I'm wondering what exactly you mean by "dump file?" Are you talking about the exp utility? How exactly are you checking this file size?

jg

--
@home.com is bogus.
http://www.toonopedia.com/today.htm