ORA-55610: Invalid DDL statement on history-tracke

删除表的时候报错

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.

转载于:https://blog.51cto.com/oramz/2105701