Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Defragmentation of SYSTEM TABLESPACE

Re: Defragmentation of SYSTEM TABLESPACE

From: PHerdmanG <pherdmang_at_aol.com>
Date: 1997/11/15
Message-ID: <19971115000801.TAA04679@ladder02.news.aol.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US