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

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

From: Robbert van der Hoorn <reply_at_forum.only>
Date: Wed, 1 Nov 2006 20:57:11 +0100
Message-ID: <4548fc1e$0$324$e4fe514c@news.xs4all.nl>

"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 Received on Wed Nov 01 2006 - 13:57:11 CST