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

TimeStamp Column Problem...
I'm mad at my self and thinking I'm a little retarded. It just be some one mistake I'm missing here.

login box shows up again after logging in 2nd login works
Hello,

I am having trouble on my site Lockerz.rack111.com where when you login the login box

insert Multiple rows into the table from that table data
Hi All,

I have a requirement like to insert mulitple rows into the table from that

Upload simple problem
Really confused!! I run once and it worked, but when i tried today...it didn't work

Which par

PHP Cannot redeclare class
I have 6 files, and two of them do not seem to want to play well. I keep getting a "Cannot rede

Limiting uploaded file type
Hi. First post here
I am working on a simple upload script, and I need it to limit the allowed f

Number Format
Hi All,

I have number '000000000050085' I want to format it to 500.85 Can any one give me

Multidimensional Array into an Html table, help!
Hello all, I am new to HTML/PHP so any help would be great.

I have a multidimensional array f

Help? Need help on project with templates involving mysql and php.
I'm having a hard time explaining what I want but basically here is what I have in place:

-Da

Output Buffering question
Hi all,

I've been trying to wrap my head around output buffering. So far I've found tons of