Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: database defragmentation :)
On Apr 3, 3:49 pm, "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?
Most of these tools became obsolete when the last version of Oracle
for the FlintStone Age (7.3) was desupported.
After that everyone converted to locally managed tablespaces, and
stopped waisting their time with futile 'exercises' like the one you
describe.
Evidently you could still 'alter tablespace coalesce' and 'alter table
move' couldn't you?
Provided you have way too much time on your hand, that is.
-- Sybrand Bakker Senior Oracle DBAReceived on Tue Apr 03 2007 - 09:05:54 CDT