Re: HOWTO: Defrag Tablespace
From: bs <shatzman_at_netcom.com>
Date: Fri, 12 Aug 1994 19:17:04 GMT
Message-ID: <shatzmanCuFs8H.CB6_at_netcom.com>
Date: Fri, 12 Aug 1994 19:17:04 GMT
Message-ID: <shatzmanCuFs8H.CB6_at_netcom.com>
Lynn Osburn (losburn_at_teal.csn.org) wrote:
: What is the "correct" method to defrag a tablespace? Export/Import
: with Compress?
: Is there an elegant solution to defrag in place?
Depends on what kind of fragmentation. If it's just compressing adjacent free extents, you can do that in place. If you mean tables with a lot of extents, Exp/Imp is it. But NEVER use compress! Better to pre-create the tables with good storage parms. In fact, if you have a good space management strategy, you should rarely, if ever, have to reorg a tablespace.
: --
: Lynn Osburn losburn_at_omcssi.com
: REAL men don't use porn.
define REAL
barry Received on Fri Aug 12 1994 - 21:17:04 CEST