FLASHBACK SESSION

Posted on Animesh KumarPosted in Uncategorized

Changing the session time in back

–step 1
select * from REGION_ANI;
begin
dbms_flashback.enable_at_time(to_timestamp(’12-03-14 17:26:06′,’dd-mm-yy hh24:mi:ss’));
end;
–step 2
select * from REGION_ANI;
–step 3
begin
dbms_flashback.disable;
end;
–run below commands from sys user
–grant execute on dbms_flashback to claims;
–create synonym claims.dbms_flashback for dbms_flashback;

The syntax for enabling flashback query will accept either a timestamp or an SCN.
If you use an SCN, then the point to which the flashback goes is precise. If you specify
a time, it will be mapped onto an SCN with a precision of three seconds.

You can query the database as of an earlier point in time, but you
can never execute DML against the older versions of the data.

273 thoughts on “FLASHBACK SESSION”

  31. I am sorting out relevant information about gate io recently, and I saw your article, and your creative ideas are of great help to me. However, I have doubts about some creative issues, can you answer them for me? I will continue to pay attention to your reply. Thanks.

    Reply

  34. I am an investor of gate io, I have consulted a lot of information, I hope to upgrade my investment strategy with a new model. Your article creation ideas have given me a lot of inspiration, but I still have some doubts. I wonder if you can help me? Thanks.

    Reply

  38. where can i get amoxicillin over the counter [url=https://amoxicillin.science/]buy amoxicillin 875 mg tablets[/url] amoxicillin 500 mg generic

    Reply

  48. Don’t waste any more time searching for a prescription. [url=https://clomid2023.online/]Buy Clomid no RX[/url] needed and take control of your fertility journey.

    Reply

  49. The [url=https://clomidium.online/]Clomid cost without insurance[/url] is heartbreaking, especially for those who have already struggled with infertility.

    Reply

  51. Your article made me suddenly realize that I am writing a thesis on gate.io. After reading your article, I have a different way of thinking, thank you. However, I still have some doubts, can you help me? Thanks.

    Reply

  102. Thank you very much for sharing. Your article was very helpful for me to build a paper on gate.io. After reading your article, I think the idea is very good and the creative techniques are also very innovative. However, I have some different opinions, and I will continue to follow your reply.

    Reply

  105. Thank you very much for sharing. Your article was very helpful for me to build a paper on gate.io. After reading your article, I think the idea is very good and the creative techniques are also very innovative. However, I have some different opinions, and I will continue to follow your reply.

    Reply

  138. I may need your help. I’ve been doing research on gate io recently, and I’ve tried a lot of different things. Later, I read your article, and I think your way of writing has given me some innovative ideas, thank you very much.

    Reply

  173. أكبر شركة لانتاج أنابيب البولي ايثيلين و يو بي سي ومستلزماتها للمنتجات الصناعية في عيراق

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

8 × = 16