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();

Did you know?Explore Trending and Topic pages for more stories like this.
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
No comments posted yet

Your Answer:

Login to answer
287 Like 23 Dislike
Previous forums Next forums
Other forums

Preg_match question
I want to use preg_match to make sure a string is always 6 characters long and only contains 0-9 and

Final year project, please point me in the right direction
hi there for my final year project I'm aiming to build a php script shell to use as an expert system

Seperate team from score
I am writing a site that does a NFL Pick 'em type application and I have a feed that gives me the sc

newbie question
Hi out thereIm totaly new in this forum and to .net and vb so here is a totaly newbie question.I wan

str_replace help
I am thinking str_replace is my only option to filter outputs from my database to convert them to sa

Displaying an image using echo command
I had done a query on my database, one of the fields being an image reference to a directory where a

Option box to change variable
Hello, i need help by making a script!

I need to write a file with option box, so a dropdown

Grabbing Values From an Array for Posting
I have a grid array that I am using with a form that when it hits the currently named test.php it lo

phpmailer class & pop.gmail.com?
Code: <?php
$mail->IsSMTP();
$mail->Host = "pop.gmail.com";

Drawing Images in classes
I'm quite new to Object Oriented PHP. What I'm trying to do is draw some images but also have other

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash