ORA-55610: Invalid DDL statement on history-tracked table解决(二)
'2013-10-28 23:27:00','YYYY-MM-DD HH24:MI:SS');
ALTER FLASHBACK ARCHIVE ARCHIVE_1 PURGE BERFOR SCN 100000000;
删除一天内的数据
ALTER FLASHBACK ARCHIVE ARCHIVE_1 PURGE BEFORE TIMESTAMP (SYSTIMESTAMP-INTERVAL '1' DAY);
删除所有的数据
alter flashback archive archive_1 purge all;
9)删除闪回归档
drop flashback archive archive_1;
10）取消表的flashback archive功能：
alter table rhys.amy no flashback archive;
11)闪回归档常用视图；
dba_flashback_archive
dba_flashback_archive_tables;