| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> find out the rollback
!! Please do not post Off Topic to this List !!
Hi lists
can anybody post me how much rollback (approx in bytes/kb/mb) will be generated if I delete my table that has 2 lakh rows.
the avg row len is 50.
often The query is getting failed due to the error unable to extend the rollback segment.
If I have this query, at least I will use a rollback segment that has enough extents.
thnx in advance.
Srinivas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
INET: Shrinivas.Tatireddy_at_med.ge.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Sep 13 2001 - 12:04:45 CDT
 |
 |