ORA-55610: Invalid DDL statement on history-tracked table
来源:互联网 发布:《淘金记》知乎 编辑:程序博客网 时间:2024/04/27 21:49
—删除表emp1时出现问题
SCOTT@GOOD> drop table emp1;drop table emp1 *ERROR at line 1:ORA-55610: Invalid DDL statement on history-tracked table
—在sys或者有权限的用户下,关闭表emp1的闪回归档
SCOTT@GOOD> conn / as sysdbaConnected.SYS@GOOD> alter table scott.emp1 no flashback archive;Table altered.
—删除emp1表
SYS@GOOD> drop table scott.emp1;Table dropped.
总结:这个错误的原因是开启了闪回归档的表不能被删除。
0 0
- ORA-55610: Invalid DDL statement on history-tracked table
- ORA-55610: Invalid DDL statement on history-tracked table (flashback archive)
- ORA-00900: invalid SQL statement
- ORA-00900:invalid SQL statement
- goldengate ddl enable,ORA-04098: trigger 'SYS.GGS_DDL_TRIGGER_BEFORE' is invalid
- ORA-29491: invalid table for chunking
- java.sql.SQLException: ORA-00903: invalid table name
- PLSQL DDL Trigger save DDL history
- invalid statement in fillwindow
- invalid statement in fillwindow
- MyBatis Invalid bound statement
- MyBatis Invalid Bound Statement
- MyBatis Invalid bound statement
- 解决异常-ORA-01747 invalid user.table.column, table.column, or column specification
- 异常-ORA-01747: invalid user.table.column, table.column, or column specification
- Oracle ORA-01747: invalid user.table.column, table.column, or column specification
- ORA-01747: invalid user.table.column, table.column, or column specification
- 解决异常-ORA-01747 invalid user.table.column, table.column, or column specification
- 给struct或union成员两个名称,其中一个用数组元素表示
- java中ConcurrentHashMap的使用及在Java 8中的冲突方案
- multimap的一些常用操作
- 设计模式之六大原则
- Collection学习(二)
- ORA-55610: Invalid DDL statement on history-tracked table
- 手机进入fastboot无法退出
- 欧拉计划 50
- hdu1251(map用法/字典树模板)
- 96 Unique Binary Search Trees
- JSP中一些常用的东西
- cpu 的simulation
- Linux下命令行安装weblogic10.3.6
- Spring中bean的定义及其作用域