删除表的时候报错
SQL> drop table u1; drop table u1 * ERROR at line 1: ORA-55610: Invalid DDL statement on history-tracked table
查询错误原因
$ oerr ora 55610 55610, 00000, "Invalid DDL statement on history-tracked table" // *Cause: An attempt was made to perform certain DDL statement that is // disallowed on tables that are enabled for Flashback Archive. // *Action: No action required.
原来是之前开了闪回日志归档，不能执行部分的DDL操作
select table_name,flashback_archive_name from dba_flashback_archive_tables; TABLE_NAME FLASHBACK_ARCHIVE_NAME 1 U1 TEST1
处理方法
SQL> alter table u1 no flashback archive;
Table altered.
SQL> drop table u1;
Table dropped.
