SQL> drop table t;

Table dropped.

SQL> create table t(id int,name varchar2(20)) tablespace example;

Table created.

SQL> insert into t
2 select 1,'yejun' from dual;

1 row created.

SQL> select dbms_rowid.rowid_block_number(rowid) blk,name from t;

BLK NAME
---------- --------------------
19088 yejun

SQL> commit;

Commit complete.

SQL> select dbms_rowid.rowid_block_number(rowid) blk,name from t;

BLK NAME
---------- --------------------
19088 yejun

SQL> alter system checkpoint;

System altered.

SQL> insert into t select 1,'yejun1' from dual;

1 row created.

SQL> select dbms_rowid.rowid_block_number(rowid) blk,name from t;

       BLK NAME
---------- --------------------
     19088 yejun
     19088 yejun1

SQL> commit;

Commit complete.

SQL> alter system checkpoint;

System altered.

SQL>

[root@oracle9ivm ora10g]# dd if=example01.dbf ibs=8192 skip=19088 count=1 | strings
1+0 records in
16+0 records out
yejun
[root@oracle9ivm ora10g]# dd if=example01.dbf ibs=8192 skip=19088 count=1 | strings
1+0 records in
16+0 records out
yejun1,
yejun
[root@oracle9ivm ora10g]#

ITPub博客

数据所在的数据块实验

最新文章