I am making database backup by export all scheme. the size did not
change after removing 70mb table (it is 60% of whole database). just
wondering if ora does not work slower (well.. .the file is bigger than
it should be (all data was from 70mb table was truncated))
On Apr 3, 6:06 pm, "joel garry" <joel-ga..._at_home.com> wrote:
> 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
Received on Tue Apr 03 2007 - 19:45:43 CDT
