ORA-55610: Invalid DDL statement on history-tracked table

RMAN報錯

ORA-55610: Invalid DDL statement on history-tracked table      

錯誤原因：表空間無法進行DDL操作，主要是因為之前有表設定了flashback archive。

處理辦法：取消flashback archive

查詢哪些表啟用了flashback archive

select * from dba_flashback_archive_tables;      

取消flashback archive

alter table test07 no flashback archive;      

至于為啥會報錯，參考Oracle ​​官方文檔​​：

DDL Statements on Tables Enabled for Flashback Data Archive Flashback Data Archive supports only these DDL statements:

​

​ALTER TABLE​

​ statement that does any of the following:

• Adds, drops, renames, or modifies a column
• Adds, drops, or renames a constraint
• Drops or truncates a partition or subpartition operation

​

​TRUNCATE TABLE​

​ statement

​

​RENAME​

​ statement that renames a table

Flashback Data Archive does not support DDL statements that move, split, merge, or coalesce partitions or subpartitions, move tables, or convert LONG columns to LOB columns.

• ​

  ​ALTER TABLE​

  ​​ statement that includes an ​

  ​UPGRADE TABLE​

  ​ clause, with or without an ​

  ​INCLUDING DATA​

  ​ clause
• ​

  ​ALTER TABLE​

  ​​ statement that moves or exchanges a partition or

  subpartition operation

• ​

  ​ DROP TABLE​

  ​ statement