数据所在的数据块实验

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]#