Re: Rollback segment question

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Fri, 20 Dec 2002 14:20:16 +1100
Message-ID: <JSvM9.6757$jM5.18973@newsfeeds.bigpond.com>

Do you have any indexes on the table? They get deleted too, and that's a segment like any other, so it needs to generate rollback too.

Throw in a few constraints, updates to the data dictionary, and other internal housekeeping, and it's not uncommon to get the sort of results you are getting.

If memory serves, this question is quite regularly asked (and answered) on this group, so a trawl through the www.google.com archives of this group should yield you similar answers, but maybe with more detail.

Regards
HJR "Murty Adavi" <adavi_at_attbi.com> wrote in message news:USvM9.399513$%m4.124469_at_rwcrnsc52.ops.asp.att.net...
> When I run a DELETE command on a table (full table DELETE, no WHERE
clause)
> of 20 MB size,
> it is taking almost 40MB space in Rollback segment. Why does it take more
> ROLLBACK space
> than the actual table size ?
>
> Tnx
>
>
Received on Thu Dec 19 2002 - 21:20:16 CST