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;
u!i^-To0
select dbms_rowid.rowid_block_number(rowid) ,stu.* from stu
select * from dba_segments ds where ds.segment_name='STU'
65511JackSmithaaaaaa
65522marySmithaaaaaa
65525marySmithaaaaaa
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: 0x7771csc: 0x01.6d2ddda9itc: 2flg: Etyp: 1 - DATA
brn: 0bdba: 0x3000289 ver: 0x01
inc: 0exflg: 0
ItlXidUbaFlagLckScn/Fsc
0x010x0003.029.0000a5c50x0082d1d2.0106.22--U-1fsc 0x0000.6d2dddaa
0x020x0003.010.0000a5c30x0082d1cf.0106.54 C---0scn 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=3offs=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: 0x0cc: 6
col0: [ 2]c1 02
col1: [ 1]00这个是分隔标记!
col2: [ 2]c1 02
col3: [ 4]4a 61 63 6b
col4: [ 5]53 6d 69 74 68
col5: [ 6]61 61 61 61 61 61
tab 0, row 1, @0x1f41
tl: 29 fb: --H-FL-- lb: 0x0cc: 6
col0: [ 2]c1 03
col1: [ 1]00这个是分隔标记!
col2: [ 2]c1 03
col3: [ 4]6d 61 72 79
col4: [ 5]53 6d 69 74 68
col5: [ 6]61 61 61 61 61 61
tab 0, row 2, @0x1f24
tl: 29 fb: --H-FL-- lb: 0x1cc: 6
col0: [ 2]c1 03
col1: [ 1]00这个是分隔标记!
col2: [ 2]c1 06
col3: [ 4]6d 61 72 79
col4: [ 5]53 6d 69 74 68
col5: [ 6]61 61 61 61 61 61
end_of_block_dump
End dump data blocks tsn: 12 file#: 12 minblk 655 maxblk 655
