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

Home -> Community -> Usenet -> c.d.o.misc -> Within a transaction, possible to save to somewhere that will not be roled back?

Within a transaction, possible to save to somewhere that will not be roled back?

From: dean <deanbrown3d_at_yahoo.com>
Date: 1 Nov 2006 11:22:03 -0800
Message-ID: <1162408922.991648.203020@m7g2000cwm.googlegroups.com> 





Hello all,



I would like a way to save the results of a query to a table, from
within a transaction, and then when I role back the transaction, that
one table to still hold the contents. I other words, can I specify that
a partivular table NOT be roled back, during a roleback call?



I want this to do testing. I realize I could export to an access
database or flat file, but that is inconvenient.



Thanks for any help,



Dean


Oracle 10g Server and Client/ Windows XP
Received on Wed Nov 01 2006 - 13:22:03 CST












Original text of this message













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