Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Within a transaction, possible to save to somewhere that will not be roled back?
Robbert van der Hoorn wrote:
> "dean" <deanbrown3d_at_yahoo.com> schreef in bericht
> news:1162408922.991648.203020_at_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
> >
>
> Although I think you should re-check your design, if you really want this,
> you could use Autonomous Transaction.
>
>
> Robbert
Thanks Robbert - at a glance that sounds like it might work. I'll look into it.
Dean Received on Thu Nov 02 2006 - 07:37:08 CST