!! 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
