RE-ORG OF A FRAGMENTED TA

From: Jared Hecker <jared.hecker_at_factory.com>
Date: 21 Jul 93 13:50:00 GMT
Message-ID: <4635.1599.uupcb_at_factory.com>


AB>What is the best way to re-organize a very large table (2 GIG) that has
AB>free space problems due to fragmentation?  The table is uses BLOBS
AB>on ORACLE7.  TIA

The way you probably already knew: export it, drop and recreate the table, import it.

hth -

jh

---
. MR/2 1.39x NR . OS/2'ing it big-time!!
Received on Wed Jul 21 1993 - 15:50:00 CEST

Original text of this message