Time out.

First of all, you don't need to re-organize your tables and indexes because you have "lots" of extents.

Oracle 8i has many new features regarding moving objects. Check out ALTER TABLE MOVE and ALTER INDEX REBUILD from the Documentation.

move: http://technet.oracle.com/docs/produ...2a.htm#2055687
rebuild: http://technet.oracle.com/docs/produ...e6.htm#2050230

[Edited by marist89 on 04-26-2002 at 03:36 PM]