Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Q: nologging question ?
sir,
oracle 8 or above
Tab_a contains 1m rows and Tab_b has 2000 rows.
Insert tab_a nologging select * from tab_b.
How would oracle rollback this operation, if nologging bypassing both redo and undo operation and above Insert operation fails ?
Thanks Ted Chyn(tedchyn_at_yahoo.com)
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Tue Aug 03 1999 - 09:47:22 CDT