Re: ANOTHER DEFRAG QUESTION
Date: 1996/04/20
Message-ID: <bobnight.32.000AF992_at_pla-net.net>#1/1
In article <3172A9A5.2633_at_explorer.csc.com> Charles Walker <cwalker_at_explorer.csc.com> writes:
>From: Charles Walker <cwalker_at_explorer.csc.com>
>Subject: ANOTHER DEFRAG QUESTION
>Date: Mon, 15 Apr 1996 12:55:17 -0700
>Hi,
>I keep reading conflicing statements from Oracle's own documentaion on
>this point. One stance is the ONLY way to defrag a tablespace is to do a
>USER export, drop and recreate the tablespace and import.
>Another says to defrag the tables in a tablespace it's OK to use a TABLE
>export, drop and recreate the table and import. My problem is I have a
>user that spans mulitple tablespaces, but want to defrag one tablespace
>at a time. Can I defrag a tablespace by defraging the tables in it?
Doing defragmentation on a per User basis makes no sense at all. A User-based strategy is just a grouping of tables and other objects by user.
The purpose of doing a reorg is to 1.) put objects back into single extents and 2.) coalese free space in a table space. By doing a tablespace-level reorg you accomplish both at the same time.
To reorg very large databases, you might want to consider a rock-solid tool that allows you to schedule reorgs, detect block-style or freespace-style fragmentation, and is considerate of RI.
PLATINUM technology's TSReorg is available for nearly every Oracle7 platform. To get more information call 800-442-6861 or 708-620-5000. You can visit our Website at http://www.platinum.com.
--Bob. Received on Sat Apr 20 1996 - 00:00:00 CEST