資料所在的資料塊實驗

tian1982tian發表於2012-10-09

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部落格 ” ，連結：http://blog.itpub.net/16400082/viewspace-745982/，如需轉載，請註明出處，否則將追究法律責任。

相關文章