object table 表2

create table stu (id number, stu studentobj);

insert into stu values(1,studentobj(1,'Jack','Smith','aaaaaa',null));

insert into stu values(2,studentobj(2,'mary','Smith','aaaaaa',null));

insert into stu values(2,studentobj(5,'mary','Smith','aaaaaa',null));

commit;

select dbms_rowid.rowid_block_number(rowid) ,stu.* from stu

select * from dba_segments ds where ds.segment_name='STU'

655 1 1 Jack Smith aaaaaa

655 2 2 mary Smith aaaaaa

655 2 5 mary Smith aaaaaa

alter system dump datafile 12 block 655;

*** 2008-05-28 17:44:41.000

Start dump data blocks tsn: 12 file#: 12 minblk 655 maxblk 655

buffer tsn: 12 rdba: 0x0300028f (12/655)

scn: 0x0001.6d2dddaa seq: 0x01 flg: 0x02 tail: 0xddaa0601

frmt: 0x02 chkval: 0x0000 type: 0x06=trans data

Block header dump: 0x0300028f

Object id on Block? Y

seg/obj: 0x7771 csc: 0x01.6d2ddda9 itc: 2 flg: E typ: 1 - DATA

brn: 0 bdba: 0x3000289 ver: 0x01

inc: 0 exflg: 0

Itl Xid Uba Flag Lck Scn/Fsc

0x01 0x0003.029.0000a5c5 0x0082d1d2.0106.22 --U- 1 fsc 0x0000.6d2dddaa

0x02 0x0003.010.0000a5c3 0x0082d1cf.0106.54 C--- 0 scn 0x0001.6d2dd3db

data_block_dump,data header at 0x4b21064

===============

tsiz: 0x1f98

hsiz: 0x18

pbl: 0x04b21064

bdba: 0x0300028f

76543210

flag=--------

ntab=1

nrow=3

frre=-1

fsbo=0x18

fseo=0x1f24

avsp=0x1f29

tosp=0x1f29

0xe:pti[0] nrow=3 offs=0

0x12:pri[0] offs=0x1f7b

0x14:pri[1] offs=0x1f41

0x16:pri[2] offs=0x1f24

block_row_dump:

tab 0, row 0, @0x1f7b

tl: 29 fb: --H-FL-- lb: 0x0 cc: 6

col 0: [ 2] c1 02

col 1: [ 1] 00 这个是分隔标记!

col 2: [ 2] c1 02

col 3: [ 4] 4a 61 63 6b

col 4: [ 5] 53 6d 69 74 68

col 5: [ 6] 61 61 61 61 61 61

tab 0, row 1, @0x1f41

tl: 29 fb: --H-FL-- lb: 0x0 cc: 6

col 0: [ 2] c1 03

col 1: [ 1] 00 这个是分隔标记!

col 2: [ 2] c1 03

col 3: [ 4] 6d 61 72 79

col 4: [ 5] 53 6d 69 74 68

col 5: [ 6] 61 61 61 61 61 61

tab 0, row 2, @0x1f24

tl: 29 fb: --H-FL-- lb: 0x1 cc: 6

col 0: [ 2] c1 03

col 1: [ 1] 00 这个是分隔标记!

col 2: [ 2] c1 06

col 3: [ 4] 6d 61 72 79

col 4: [ 5] 53 6d 69 74 68

col 5: [ 6] 61 61 61 61 61 61

end_of_block_dump

End dump data blocks tsn: 12 file#: 12 minblk 655 maxblk 655

Trackback URL: http://blog.itpub.net//trackback.php?id=465022