Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Rollback segment question

Rollback segment question

From: Murty Adavi <adavi_at_attbi.com>
Date: Fri, 20 Dec 2002 03:10:44 GMT
Message-ID: <USvM9.399513$%m4.124469@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:10:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US