Hi,
In fact, there is no way to commit individual statement as we know so far.
You may try:
Redo the necessary statement in the Rollback session.
OR
Output the log info. to a text file and load it at anytime.
:) Wilfred
>hello,
>
>how to commit "local" update during big transaction.
>ie: i want to be able to rollback a large transaction with lots of
>update, delete... and TO KEEP modifications done to a certain table (a unique one, on a distant base, all queries are executed from this base via dblinks),
>the table to keep is used for debugging info (very large,dbms_output is not enough large))
>
>thanks
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement