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>
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