Oracle数据库一些简单的数据恢复

SELECT DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER FROM DUAL   结果： 156494485SELECT * FROM HSE_PPE_FHPKC AS OF SCN 156494485 这个数字可以操作 加1或者减1SELECT * FROM FLASHBACK_TRANSACTION_QUERY WHERE TABLE_NAME='HSE_PPE_FHPKC' --闪回表SELECT * FROM RECYCLEBIN --查询被删掉的表或者视图FLASHBACK TABLE HSE_PPE_FHPKC TO BEFORE DROP --闪回被删掉的表