quick question about System Change Number(SCN) in FlashBack Query topic

Posted on 16th Feb 2014 07:03 pm by admin

i know tht we can get the SCN of the database using flashback concept as follows

SQL> execute :myvariable:=dbms_flashback.get_system_change_number();

PL/SQL procedure successfully completed.

SQL> print myvariable;

MYVARIABLE
451578

for example i made some insertions into a table after this and commit is executed. If i want to rollback this transaction thn i can use

SQL> execute dbms_flashback.enable_at_system_change_number(:myvariable);

PL/SQL procedure successfully completed.

but what if i dont know the SCN of the database before the transaction(insertion in to the table). If i want to rollback the database to state where i don't know the SCN of that particular state, thn how can i do tht.

i know tht we can do it using timestamp method....but i want to know how we can use this SCN concept in this situation.
Thanks

Your Answer:

Login to answer

Other forums

Multiple submit forms inside a mysql array page
Hi all,

Im having trouble to get the beneath script to work the thing i can't seem to get wor

Send inserts to mysql thru port 80
Hi!

I have an application that must do some inserts in a mysql db. This db is behind a firewa

PHP form help required
Hi all! Apologies in advance for having to message the forum for help. I know you must get a lot of

form problem
below in the form action, i've put "test.php?w=$sw&h=$sh" but when i input the for

How to make a mail Form secure?
I want to create an email Form on my web site. How can I make the Form secure so the submitted info

form variables from database help.
Hi all,

I would like to have a form that gives you options based on the results of an mysql q

undefined offset help
Hi All,

I kept getting undefined offset PHP notice for a simple for loop. For eg
$va = arr

date("now") prints out wrong date ?
Hi Guys
Anyone know why and how I can fix it ?

Wierd echo error?
Hi, i got the most wierd php error ever and i don't know why..
Code: echo "<t

Require select-option functionality in Module Pool Programming
Hi Gurus,

I am doing a development by Module Pool on Warehouse Management. For that devel