11gR2新特性体验

〇〇

1.5.1.1 Flashback Data Archive Support for DDLs
Oracle Database 11g Release 2 (11.2) users can now use most DDL commands on tables that are being tracked with Flashback Data Archive. This includes:

Add, Drop, Rename, Modify Column

Drop, Truncate Partition

Rename, Truncate Table

Add, Drop, Rename, Modify Constraint

For more complex DDL (for example, upgrades and split table), the Disassociate and Associate PL/SQL procedures can be used to temporarily disable Total Recall on specified tables. The Associate procedure enforces schema integrity after association; the base table and history table schemas must be the same.

This feature makes it much easier to use the Total Recall option with complex applications that require the ability to modify the schema.

[ 本帖最后由 〇〇 于 2009-9-14 10:51 编辑 ]

〇〇

查询truncate前的数据失败，但在建表前未定义可以查询

〇〇

修改表结构V1 VARCHAR(20)

〇〇

在虚拟机Flashback Data Archive 这个功能启用后,insert truncate都很慢
谁有真实物理机测试下

luckyrandom

汗+感慨！
Oracle的数据显示字符格式看着头晕。。。当然理解它的多平台特性
还是SQL SERVER的GRID风格看着顺眼