Stay home. Save Lives
How to Restore Some Data or a Whole Table on Oracle?

How to Restore Some Data or a Whole Table on Oracle?

Accidentally dropping a table  can be a career ending action is if you made in production environment. 

The best ways is to use the FLASHBACK TABLE statement to restore an earlier state of a table in the event of human or application error. The time in the past to which the table can be flashed back is dependent on the amount of undo data in the system. Also, Oracle Database cannot restore a table to an earlier state across any DDL operations that change the structure of the table.

You may also Like

What’s Big Query?

What’s Big Query?

April 30, 2020
Selection Sort Algorithm

Selection Sort Algorithm

July 23, 2019

Leave a reply

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

About Me

I am a dad of two wonderful boys, Utku Efe and Omer Eren, and married with the love of my life, Elif. In addition, I am an academician and AI/ML scientist because I worked more than 15 years in universities, have M.S and Ph.D. thesis and more than 20 scientific papers/presentations and 100 citations. Now people call me as a Principal Developer in my last company :).
I am really hungry on learning new technologies and get more fun while developing new softwares.

Stay Connected

Recent Posts


MongoDB Indexes


What’s Big Query?


Categories

×