rowid format and the format of a row piece

本文详细介绍了数据库中RowID的组成及其各个部分的作用,包括数据对象编号、数据文件编号、数据块编号及行号等,并解释了在特殊情况下RowID可能会发生变化的原因。

rowid format:


■ OOOOOO
The data object number identifies the segment (data object AAAPec in 
Example 12–1). A data object number is assigned to every database segment. 
Schema objects in the same segment, such as a table cluster, have the same data 
object number.
■ FFF
The tablespace-relative data file number identifies the data file that contains the 
row (file AAF in Example 12–1).
■ BBBBBB
The data block number identifies the block that contains the row (block AAAABS in 
Example 12–1). Block numbers are relative to their data file, not their tablespace. 
Thus, two rows with identical block numbers could reside in different data files of 
the same tablespace.
■ RRR
The row number identifies the row in the block (row AAA in Example 12–1). 
After a rowid is assigned to a row piece, the rowid can change in special 
circumstances. For example, if row movement is enabled, then the rowid can change 
because of partition key updates, Flashback Table operations, shrink table operations, 
and so on. If row movement is disabled, then a rowid can change if the row is exported 
and imported using Oracle Database utilities.


二、the format of a row piece


评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值