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

foreach help.
Hello all,

First time I'm attempting to use a foreach statement and was just wondering if my

Need Reporting Advice
My SQL server doesn't support MS SQL reporting services that comes with SQL Enterprise or Express. T

How to give the privillege for triggers?
Hi,

How to give the privillage for triggers to particular user?

Please let me

Match stored value with the current value in a loop
Hello,

I have a MySQL db were I store articles in.

I have a form to fill these article

Run function every 5 mins ??
I have a function PostMessage()

How can I run it every 5 mins ??

Beginner PHP code help
Hi I'm new to php but if someone could please read the question below and help it would be great.

=> and <=
So I was digging through some code when I came across the <= operator. This is the first tim

How to read CSS message data
Hi,
I have a requirement here. When working as a Dev angel for multiple customers its really di

parameter passing issue on function
Well I thought I had created a pretty slick web page, using ?page and $_GET to load pages which wher

'grab_files', multiple extension?
hey guys,

can anyone suggest a way to make to following line of code look for files with more