精彩网络 LookData

1. alter session set nls_date_format=’yyyy-mm-dd hh24:mi:ss’; 2. SELECT OLDEST_FLASHBACK_SCN, OLDEST_FLASHBACK_TIME FROM V$FLASHBACK_DATABASE_LOG; 3. shutdown immediate; 3. startup mount 4. flashback database to scn xxx FLASHBACK DATABASE TO TIMESTAMP to_timestamp(’2002-11-11 16:00:00′, ‘YYYY-MM-DD HH24:MI:SS’);