053-25

You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is
supported on the table after enabling Flashback Data Archive?
A. Drop the table.
B. Partition the table
C. Truncate the table.
D. Add a column to the table.
E. Rename a column in the table.

闪回数据归档:DDL限制
启用以下任何一DDL语句都会导致ORA-55610
* 执行一下任一操作的ALTER TABLE语句:
 -删除、重命名或修改列
 -执行分区或者子分区操作
 -将LONG列转换位LOB列
 -包括UPGRADE TABLE子句(不管有无INCLUDING DATA子句)
 * DROP TABLE语句
 * TRUNCATE TABLE语句

posted @ 2018-01-05 17:52  巴啦啦大魔王  阅读(147)  评论(0编辑  收藏  举报