Re: resizing tables in Oracle 8

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Wed, 03 Nov 1999 10:21:34 -0800
Message-ID: <38207D2D.B85A0F9E@vnl.nl>

Joshua Ford wrote:

> Can anyone tell me how to dynamically resize a table in Oracle 8. I have
> this app that needs to do lots of inserts to specific tables, then massage
> that data send it off to other apps and then delete it. My problem is that
> the table(s) large (results in fragmentation). Truncating the table and
> then exporting and reimporting the table is not an option. Any ideas
>
> -**** Posted from RemarQ, http://www.remarq.com/?a ****-
> Search and Read Usenet Discussions in your Browser - FREE -

Why bother about fragmentation? I'd be bother about dynamically allocating extends and freelists, not about fragmentation.

--
Met vriendelijke groet/kind regards,

Frank van Bortel
Technical consultant Oracle

Work:                                Home:
----------------------------------   ----------------------------
Inter Access V&L                     Hunzestraat 4
Palatijn 3, 7521 PN Enschede         7555 WB Hengelo
PoBox 545, 7500 AM Enschede          (31)074-2425046

053-4341500 Received on Wed Nov 03 1999 - 12:21:34 CST