Oracle - 3 - 【学习笔记】for ocp 12c、12C新特性之ROW ARCHIVE

http://abner.blog.chinaunix.net/uid-20785090-id-4445403.html

ora_archive_state，默认值为0，表示该行对应用程序可见.

SQL>   alter table aa row archival; 

Table altered


SQL> select column_name from user_tab_cols where table_name='AA';

COLUMN_NAME
--------------------------------------------------------------------------------
C1
C2
SYS_NC00003$
ORA_ARCHIVE_STATE

SQL> select * from aa;

                                     C1 C2
--------------------------------------- --------------------------------------------------------------------------------
                                    222 222
                                    333 333

SQL> select c1,c2,ora_archive_state from aa;

                                     C1 C2                                                                               ORA_ARCHIVE_STATE
--------------------------------------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------
                                    222 222                                                                              0
                                    333 333                                                                              0

删除、逻辑删除

SQL> delete aa where c1=222  ;

1 row deleted


SQL> commit; 

Commit complete


SQL> update aa set ora_archive_state=1 where c1=333;

1 row updated


SQL> select * from aa;

                                     C1 C2
--------------------------------------- --------------------------------------------------------------------------------

SQL>  alter session set row archival visibility=ALL;

Session altered


SQL> select * from aa; 

                                     C1 C2
--------------------------------------- --------------------------------------------------------------------------------
                                    333 333

SQL>  alter session set row archival visibility=active;

Session altered

SQL> select * from aa;

                                     C1 C2
--------------------------------------- --------------------------------------------------------------------------------

Oracle 字段监控 ( column monitor)
database based on activity tracking columns
https://www.cnblogs.com/halberd-lee/p/11068656.html