SCOTT@GOOD> droptableemp1; droptableemp1 * ERROR at line1: ORA-55610: Invalid DDL statement on history-trackedtable —在sys或者有权限的用户下,关闭表emp1的闪回归档 SCOTT@GOOD> conn / as sysdba Connected. SYS@GOOD> alter table scott.emp1noflashback archive; Table altered. —删除emp1表 SY...
/u01/oradata/prod/redo01.logORA-00283: 恢复会话因错误而取消ORA-01244: 未命名的数据文件由介质恢复添加至控制文件ORA-01110: 数据文件 3: '/u01/oradata/prod/abcd01.dbf'ORA-01112: 未启动介质恢复SQL> select file#,checkpoint_change#,name from v$datafile;FILE# CHECKPOINT_CHANGE# NAME--- --- -...
(3)RENAME statement that renames a table Some DDL statements cause error ORA-55610 when used on a table enabled for Flashback Data Archive. For example: -- 启动Flashback Data Archive的表上的一些DDL 操作可能触发ORA-55610的错误,这些DDL 如下: (1)ALTER TABLE statement that includes an UPGRADE ...
drop table test_table_delete ORA-55610: 针对历史记录跟踪表的 DDL 语句无效 SQL> EXEC DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA('LIJIAN','TEST_TABLE_DELETE'); PL/SQL procedure successfully completed SQL> drop table test_table_delete; drop table test_table_delete ORA-55610: 针对历史记录跟踪表的 D...
ORA-55610: 针对历史记录跟踪表的 DDL 语句无效。(修改列删除列,清空记录可以 但是不能删除) drop table emp1;(11gR2上也不行) 下面演示取消归档保护 sys: 查看有哪些归档名 SQL> select owner_name,flashback_archive_name from dba_flashback_archive; ...
ORA-55610: Invalid DDL statement on history-tracked table 哪些ddl可以在开启历史表的的表上操作? 1、对字段的add、drop、rename、modify修改2、对约束的add、drop、rename修改3、对分区的drop、truncate操作4、对表的truncate和rename操作 三、flashback transaction query ...
--启动Flashback Data Archive的表上的一些DDL操作可能触发ORA-55610的错误,这些DDL如下: (1)ALTER TABLE statement that includes an UPGRADE TABLE clause, with or without an INCLUDING DATA clause (3)ALTER TABLE statement that moves or exchanges a partition or subpartition operation ...
ORA-55610: Invalid DDL statement on history-tracked table Now the trap … Oracle does however allow you to add any other type of constraint, such as say a Primary Key, without complaint: SQL> alter table bowie_recall add primary key (id); ...
ORA-55610: Invalid DDL statement on history-tracked table Elapsed: 00:00:00.04 scott@clonepdb_plugPDB> insert into test select empno,ename from emp; 12 rows created. Elapsed: 00:00:00.03 scott@clonepdb_plugPDB> commit 2 ; Commit complete. ...
In addition, there are certain DDL restrictions associated with having flashback archiving enabled in 11gR1. The following operations result in a ORA-55610 error. ALTER TABLEstatements that drop, rename or modify columns. ALTER TABLEstatements that performs partition or subpartition operations. ...