31 Temmuz 2014 Perşembe

RECYCLE BIN,FLASHBACK

After dropping tables,it is feared to lose datas but still recoverable.

Just like in operating systems,dropping tables means throwing recyclebin.
As it is displayed in picture,there you can see the tables dropped with its details.
Let's see something different.




I will somehow recover the datas from COPY_EMP table with its object name like here;




I have created a table named it turkey with two columns; city and plate_number respectively.I manipulated it with insert statement then dropped it.

The flashback is run on to recover table to its previous state. Good one !




Hiç yorum yok:

Yorum Gönder