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

LIMIT $start, 10... how to pass last value queried into next page with GET??
Ok I know how to display the first or last 10 results of a query...

$result = mysql_query(&q

Logic question
im wondering what's the best method to do the above list:

it is for alliance @ MMORPG game

utf8_general_ci error ??
I have all kinds of data to be inserted in database table

//I am getting this error

Yo

New Search Engine
Hey everyone,

I have a ZIP Code Radius search engine already functional. it displays all of t

Estimations and Effort
HI Gurus,

Would like to know whether SAP have a provision for carrying out the Project es

How to secure my login data to my database?
Hi there,

It may be a stupid question but I don't know how to secure my login data to my data

a dificult string search
Hi I don't know a way around this. I want the user to input a password, but to make it a bit complca

Standard DES encryption script?
Can anybody point me to a tutorial or a short script that shows how to encrypt some text with salt i

Beginners syntax and loop questions - help please!
Hi everyone,

I have some problems with php code. I'm currently in the middle of learning php,

sql error
I have been looking at this code for 20mins and can't work out what I am doing wrong. There is somet