Hi Netbar,
If you are on 8i you can move tables (or table partitions) to new locally managed tablespaces and rebuild your indexes in new locally managed tablespaces. Drop your old tablespace when all contents are transfered.
This will reorg your database.
Tycho




Reply With Quote