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 -> commit afer unable to extend rollback segment

commit afer unable to extend rollback segment

From: Sasha Ostojic <sasha_at_UltimateTech.com>
Date: 1997/10/17
Message-ID: <628jpd$r8b$1@news-sj-3.cisco.com>#1/1

If I do "DELETE FROM my_table", and it eventually comes back with an error saying "unable to extend rollback segment", is it OK to do a COMMIT? Will the COMMIT purge any of the records that made it into the rollback segment before it filled up? Or am I asking for trouble if I do this?

I would prefere to do this rather than extend the rollback segment because it is a one-time thing.

Thanks,
.sasha Received on Fri Oct 17 1997 - 00:00:00 CDT

Original text of this message

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