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

#1

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

#2

"dean" <deanbrown3d (AT) yahoo (DOT) com> schreef in bericht
news:1162408922.991648.203020 (AT) m7g2000cwm (DOT) googlegroups.com...

Quote:

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

#3

Robbert van der Hoorn wrote:

Quote:

"dean" <deanbrown3d (AT) yahoo (DOT) com> schreef in bericht
news:1162408922.991648.203020 (AT) m7g2000cwm (DOT) 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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

comp.databases.oracle.misc comp.databases.oracle.misc

Within a transaction, possible to save to somewhere that will not be roled back? - 11-01-2006 , 01:22 PM

Re: Within a transaction, possible to save to somewhere that will not be roled back? - 11-01-2006 , 01:57 PM

Re: Within a transaction, possible to save to somewhere that will not be roled back? - 11-02-2006 , 07:37 AM