ORA-55610: Invalid DDL statement on history-tracked table 1. 错误原因:表空间无法进行DDL操作,主要是因为之前有表设置了flashback archive。 处理办法:取消flashback archive 查询哪些表启用了flashback archive select*fromdba_flashback_archive_tables; 1. 取消flashback archive altertabletest07 no flashback a...
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 forFlas...
情况分析 置于Flashback data archive中的table的一些限制 追踪表(Trackedtable),也就是指定将历史数据保存到某个flashback data archive中的table,不能执行DDL操作(addcolumn除外)。 NING@11g>droptabletest;droptabletest*ERROR at line1: ORA-55610: Invalid DDL statementonhistory-trackedtableNING@11g>truncatetab...
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 ...
ORA-55610: Invalid DDL statementonhistory-trackedtable 情况分析 置于Flashback data archive中的table的一些限制 追踪表(Trackedtable),也就是指定将历史数据保存到某个flashback data archive中的table,不能执行DDL操作(addcolumn除外)。 NING@11g>droptabletest;droptabletest*ERROR at line1: ...
追踪表(Trackedtable),也就是指定将历史数据保存到某个flashback data archive中的table,不能执行DDL操作(addcolumn除外)。 NING@11g>droptabletest;droptabletest*ERROR at line1: ORA-55610: Invalid DDL statementonhistory-trackedtableNING@11g>truncatetabletest;truncatetabletest*ERROR at line1: ...