SQL> flashback database to scn 588975;
flashback database to scn 588975
*
ERROR at line 1:
ORA-38729: Not enough flashback database log data to do FLASHBACK.
flashback database to scn 588975
*
ERROR at line 1:
ORA-38729: Not enough flashback database log data to do FLASHBACK.
SELECT START_SCN,operation, undo_sql
FROM FLASHBACK_TRANSACTION_QUERY where table_name='EMP1';
用这条语句查询一下先!
table_name 要用你的表;
如果回复系统
SELECT estimated_flashback_size,flashback_size FROM V$FLASHBACK_DATABASE_LOG;SELECT oldest_flashback_scn,oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG;SELECT * FROM V$FLASHBACK_DATABASE_STAT;
select dbms_flashback.get_system_change_number() from dual;SELECT name, space_limit AS quota,space_used AS used,space_reclaimable AS reclaimable,
number_of_files AS files FROM v$recovery_file_dest ;
查到scn
FLASHBACK DATABASE TO SCN #####;
dinya2003 人不错哦!