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

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 columnAdds, drops, or renames a constraintDrops 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.

For example, the following DDL statements cause error ORA-55610 when used on a table enabled for Flashback Data Archive:

​​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

If you must use unsupported DDL statements on a table enabled for Flashback Data Archive, use the ​​DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA​​​ procedure to disassociate the base table from its Flashback Data Archive. To reassociate the Flashback Data Archive with the base table afterward, use the ​​DBMS_FLASHBACK_ARCHIVE.REASSOCIATE_FBA ​​procedure.

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。