Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Defragmentation of SYSTEM TABLESPACE
Not sure whether it is defaulted in export, but compress=y is the key on export, drop, re-create, import. This will compress a total of bytes for all existing extents to a single initial extent. Worth noting that Oracle's exp compress=y does not free unused space!!
This caught me out in a real situation, deleted lots of rows... performed exp compress=y, re-create, imp (no extra free space).
Had to precreate tables and indexes and then import data with commit=y.
Regards,
PeterHG.
Received on Sat Nov 15 1997 - 00:00:00 CST