oracle total,数据库 – 是Oracle Total Recall的替代方案吗?

Flashback Data Archive creates an

internal history table for every

tracked table. The internal history

table is initially a replica of the

FDA-enabled table with additional

Metadata columns. When one or more

columns in the tracked table are

updated,a new row is inserted into

the history table that is the

before-image of the row before the

transaction. UPDATE and DELETE

operations generate a new record in

the history table,but INSERT

operations do not – inserted rows

appear in the base table. The internal

history table is partitioned for

better performance,and compressed to

reduce disk space requirements. No

modifications are allowed to internal

history tables. Applications and users

can use the ‘AS OF’ and ‘VERSIONS

BETWEEN’ sql constructs to seamlessly

query the historical data.

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值