Re: Fragmentation in Oracle

Jorge A. San Martín wrote:

> Hi,
> I'm using Oracle 7.3.2.3 on an Alpha with OSF/1 v4.0, and I have some
> questions.
> First, fragmentation problem exist?
> Second, I have a process what makes "depuration", it does not delete all
> the records from a table, just the ones that meet a condition, I
> suppose that this operation makes some fragmentation, how can I fix
> this? I'm thinking of making an export of the table, truncate it and
> import it, but this is very ineficient, we are calculating 1,000,000
> records a day :(
> What would you recomend?
>
> That is all, thanks,
>
> Jorge San Martin

It's me again, my e-mail is

    jsanmart_at_dcc.uchile.cl Received on Thu Nov 06 1997 - 00:00:00 CET