12c In-Database Archiving
来源:互联网 发布:淘宝怎么设置最低折扣 编辑:程序博客网 时间:2024/05/21 17:21
为准备12c ocp升级考试
12c建议把历史数据也放置到在线的数据库中,可参考12c的ILM和VLDB部分。
In-Database Archiving可以把表中的行标记为inactive,从而达到对此行进行archive的目的。
数据库可以对inactive的数据进行压缩,对于应用来说这些inactive的数据也是不可见的。通过此特性,在单个数据库中可以支持存储更长历史时长的数据
要启用此特性,我们在创建表时必须加上row archival,数据库会自动为新创建的表添加ORA_ARCHIVE_STATE隐藏列。
并且,数据库通过一个会话级参数row archival visibility来控制inactive的数据是否可见。如下
SQL> alter session set row archival visibility=active;
Session altered.
SQL> create table test2(id number,name varchar2(12))row archival;
Table created.
SQL> desc test2
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER
NAME VARCHAR2(12)
SQL> insert into test2 values(1,'tom');
1 row created.
SQL> insert into test2 values(2,'mary');
1 row created.
SQL> commit;
Commit complete.
SQL> col column_name for a20
SQL> select column_name,hidden_column from user_tab_cols where table_name='TEST2';
COLUMN_NAME HID
-------------------- ---
ORA_ARCHIVE_STATE YES
ID NO
NAME NO
SQL> col ORA_ARCHIVE_STATE for a20
SQL> select id,ORA_ARCHIVE_STATE from test2;
ID ORA_ARCHIVE_STATE
---------- --------------------
1 0
2 0
SQL> update test2 set ORA_ARCHIVE_STATE=1 where id=2;
----Insert a value into ORA_ARCHIVE_STATE to set inactive
1 row updated.
SQL> select id,ORA_ARCHIVE_STATE from test2;
ID ORA_ARCHIVE_STATE
---------- --------------------
1 0
SQL> alter session set row archival visibility=all;
Session altered.
SQL> select id,ORA_ARCHIVE_STATE from test2;
ID ORA_ARCHIVE_STATE
---------- --------------------
1 0
2 1
- 12c In-Database Archiving
- Oracle 12c 新特性之 In-Database Archiving
- Oracle Database 12c新特性 In-Database Archiving数据库内归档
- Oracle 12c 新特性之 数据库内归档(In-Database Archiving)
- 72.You want to enable archiving on your database. Presently, the database is running in NOARCHIVELOG
- Changing the Database Archiving Mode
- Object-c Archiving归档
- 第八章configuring the database archiving mode
- Archiving
- Oracle Database 12c In-Memory 基本原理与简介
- Oracle Database 12c In-Memory 学习推荐博文
- Obect-C:Archiving归档小结
- how to changing the RAC 10g Database Archiving Mode
- EM 12c : How to Manually add Database Target in Cloud Control 12c
- Archiving Objective-C Objects with NSCoding
- Archiving Objective-C Objects with NSCoding
- Connecting to Container Databases (CDB) and Pluggable Databases (PDB) in Oracle Database 12c
- WITH Clause Enhancements in Oracle Database 12c Release 1 (12.1)
- Caused by: java.lang.ClassCastException: android.widget.LinearLayout$LayoutParams
- java中实现自定义注解
- 修改php-fpm进程数
- Exception handling in java
- android MotionEvent.ACTION_DOWN 事件丢失
- 12c In-Database Archiving
- 深入掌JMS
- 【JSP引入报错】--package javax.servlet.jsp does not exist
- 修改eclipse中的默认maven2资源仓库保存地址(很有用的)
- Xcode 删除及重新安装cocos2dx模版
- 普通javascript的,jquery的,Extjs的ajax实现与比较
- POJ 1552 Doubles
- sigaction的sa_flags
- CoCreateInstanceEx详解