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

No comments posted yet

Your Answer:

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

getting most records by count
Code: [Select]<?php

$connect = mysql_connect("localhost","dam

Help with page encoding issue and weird characters
I'm trying to write a screen scraper and when I pull out the lines of the html file that I'm interes

Searching keywords from array
Hello everyone, Im just wondering if someone could help me with another issue im having. Im still le

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

count only commas outside parenteses
I have a sql table containing
id - query - query name
the first page contains a drop down men

Little problem with form insertion in MySQL, Please help!!!
Hi!,

I'm a little bit new with php and I have a little issue here. I created a webform to ins

Ten Operator Syntax
Hi Guys,

I can't figure out why i am getting a parse error with this basic ten op code:

how to hide input fields on selection screen using variant attribute
Hello all,

I want to know how to hide input fields on selection screen using variant attr

Target costs on Process orders not calculating
Hi All,

We have released standard costs for all the materials. We have also done Goods r

Php Mysql Page Loading Notice
Hi all,

I was wondering if there is a way (Sure there is) of showing a message or an image wh

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