如何dump某個表的資料快

paulyibinyi發表於2007-12-28
sql>create table a as select * from test where rownum<100;
paul@TEST(192.168.1.117)> select rowid ,
2 dbms_rowid.rowid_relative_fno(rowid) file_no,
3 dbms_rowid.rowid_block_number(rowid) block_number
4 from paul.A where rownum<5;

ROWID FILE_NO BLOCK_NUMBER
------------------ ---------- ------------
AAABntAAGAAAAD8AAA 6 252
AAABntAAGAAAAD8AAB 6 252
AAABntAAGAAAAD8AAC 6 252
AAABntAAGAAAAD8AAD 6 252

已用時間: 00: 00: 00.00
paul@TEST(192.168.1.117)> alter system dump datafile 6 block 252;

系統已更改。
dump出來的內容如下,包括對這個表的這個塊事物和與回滾段槽相關資訊,
深入研究
*** 2007-08-28 17:41:48.349
Start dump data blocks tsn: 6 file#: 6 minblk 252 maxblk 252
buffer tsn: 6 rdba: 0x018000fc (6/252)
scn: 0x0000.001c4613 seq: 0x01 flg: 0x06 tail: 0x46130601
frmt: 0x02 chkval: 0x6b64 type: 0x06=trans data
Block header dump: 0x018000fc
Object id on Block? Y
seg/obj: 0x19ed csc: 0x00.1c37cb itc: 3 flg: E typ: 1 - DATA
brn: 0 bdba: 0x18000f9 ver: 0x01
inc: 0 exflg: 0

Itl Xid Uba Flag Lck Scn/Fsc
0x01 0xffff.000.00000000 0x00000000.0000.00 C--- 0 scn 0x0000.001c37cb
0x02 0x0006.013.0000005e 0x0080013c.005b.19 --U- 5 fsc 0x0000.001c3857
0x03 0x0008.004.00000063 0x00800082.005b.10 --U- 5 fsc 0x0000.001c4613

data_block_dump,data header at 0x550107c
===============
tsiz: 0x1f80
hsiz: 0xd8
pbl: 0x0550107c
bdba: 0x018000fc
76543210
flag=--------
ntab=1
nrow=99
frre=-1
fsbo=0xd8
fseo=0x1bec
avsp=0x1b2d
tosp=0x1b2d
0xe:pti[0] nrow=99 ffs=0
0x12:pri[0] ffs=0x1f7a
0x14:pri[1] ffs=0x1c00
0x16:pri[2] ffs=0x1f68
0x18:pri[3] ffs=0x1bfb
0x1a:pri[4] ffs=0x1f56
0x1c:pri[5] ffs=0x1bf6
0x1e:pri[6] ffs=0x1f44
0x20:pri[7] ffs=0x1bf1
0x22:pri[8] ffs=0x1f32
0x24:pri[9] ffs=0x1f29
0x26:pri[10] ffs=0x1f20
0x28:pri[11] ffs=0x1f17
0x2a:pri[12] ffs=0x1f0e
0x2c:pri[13] ffs=0x1f05
0x2e:pri[14] ffs=0x1efc
0x30:pri[15] ffs=0x1ef3
0x32:pri[16] ffs=0x1eea
0x34:pri[17] ffs=0x1ee1
0x36:pri[18] ffs=0x1ed8
0x38:pri[19] ffs=0x1ecf
0x3a:pri[20] ffs=0x1ec6
0x3c:pri[21] ffs=0x1ebd
0x3e:pri[22] ffs=0x1eb4
0x40:pri[23] ffs=0x1eab
0x42:pri[24] ffs=0x1ea2
0x44:pri[25] ffs=0x1e99
0x46:pri[26] ffs=0x1e90
0x48:pri[27] ffs=0x1e87
0x4a:pri[28] ffs=0x1e7e
0x4c:pri[29] ffs=0x1e75
0x4e:pri[30] ffs=0x1e6c
0x50:pri[31] ffs=0x1e63
0x52:pri[32] ffs=0x1e5a
0x54:pri[33] ffs=0x1e51
0x56:pri[34] ffs=0x1e48
0x58:pri[35] ffs=0x1e3f
0x5a:pri[36] ffs=0x1e36
0x5c:pri[37] ffs=0x1e2d
0x5e:pri[38] ffs=0x1e24
0x60:pri[39] ffs=0x1e1b
0x62:pri[40] ffs=0x1e12
0x64:pri[41] ffs=0x1e09
0x66:pri[42] ffs=0x1e00
0x68:pri[43] ffs=0x1df7
0x6a:pri[44] ffs=0x1dee
0x6c:pri[45] ffs=0x1de5
0x6e:pri[46] ffs=0x1ddc
0x70:pri[47] ffs=0x1dd3
0x72:pri[48] ffs=0x1dca
0x74:pri[49] ffs=0x1bec
0x76:pri[50] ffs=0x1db8
0x78:pri[51] ffs=0x1daf
0x7a:pri[52] ffs=0x1da6
0x7c:pri[53] ffs=0x1d9d
0x7e:pri[54] ffs=0x1d94
0x80:pri[55] ffs=0x1d8b
0x82:pri[56] ffs=0x1d82
0x84:pri[57] ffs=0x1d79
0x86:pri[58] ffs=0x1d70
0x88:pri[59] ffs=0x1d67
0x8a:pri[60] ffs=0x1d5e
0x8c:pri[61] ffs=0x1d55
0x8e:pri[62] ffs=0x1d4c
0x90:pri[63] ffs=0x1d43
0x92:pri[64] ffs=0x1d3a
0x94:pri[65] ffs=0x1d31
0x96:pri[66] ffs=0x1d28
0x98:pri[67] ffs=0x1d1f
0x9a:pri[68] ffs=0x1d16
0x9c:pri[69] ffs=0x1d0d
0x9e:pri[70] ffs=0x1d04
0xa0:pri[71] ffs=0x1cfb
0xa2:pri[72] ffs=0x1cf2
0xa4:pri[73] ffs=0x1ce9
0xa6:pri[74] ffs=0x1ce0
0xa8:pri[75] ffs=0x1cd7
0xaa:pri[76] ffs=0x1cce
0xac:pri[77] ffs=0x1cc5
0xae:pri[78] ffs=0x1cbc
0xb0:pri[79] ffs=0x1cb3
0xb2:pri[80] ffs=0x1caa
0xb4:pri[81] ffs=0x1ca1
0xb6:pri[82] ffs=0x1c98
0xb8:pri[83] ffs=0x1c8f
0xba:pri[84] ffs=0x1c86
0xbc:pri[85] ffs=0x1c7d
0xbe:pri[86] ffs=0x1c74
0xc0:pri[87] ffs=0x1c6b
0xc2:pri[88] ffs=0x1c62
0xc4:pri[89] ffs=0x1c59
0xc6:pri[90] ffs=0x1c50
0xc8:pri[91] ffs=0x1c47
0xca:pri[92] ffs=0x1c3e
0xcc:pri[93] ffs=0x1c35
0xce:pri[94] ffs=0x1c2c
0xd0:pri[95] ffs=0x1c23
0xd2:pri[96] ffs=0x1c1a
0xd4:pri[97] ffs=0x1c11
0xd6:pri[98] ffs=0x1c08
block_row_dump:
tab 0, row 0, @0x1f7a
tl: 6 fb: --H-FL-- lb: 0x2 cc: 1
col 0: [ 2] c2 02
tab 0, row 1, @0x1c00
tl: 5 fb: --H-FL-- lb: 0x3 cc: 1
col 0: [ 1] 80
tab 0, row 2, @0x1f68
tl: 6 fb: --H-FL-- lb: 0x2 cc: 1
col 0: [ 2] c2 02
tab 0, row 3, @0x1bfb
tl: 5 fb: --H-FL-- lb: 0x3 cc: 1
col 0: [ 1] 80
tab 0, row 4, @0x1f56
tl: 6 fb: --H-FL-- lb: 0x2 cc: 1
col 0: [ 2] c2 02
tab 0, row 5, @0x1bf6
tl: 5 fb: --H-FL-- lb: 0x3 cc: 1
col 0: [ 1] 80
tab 0, row 6, @0x1f44
tl: 6 fb: --H-FL-- lb: 0x2 cc: 1
col 0: [ 2] c2 02
tab 0, row 7, @0x1bf1
tl: 5 fb: --H-FL-- lb: 0x3 cc: 1
col 0: [ 1] 80
tab 0, row 8, @0x1f32
tl: 6 fb: --H-FL-- lb: 0x2 cc: 1
col 0: [ 2] c2 02
tab 0, row 9, @0x1f29
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 0b
tab 0, row 10, @0x1f20
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 0c
tab 0, row 11, @0x1f17
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 0d
tab 0, row 12, @0x1f0e
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 0e
tab 0, row 13, @0x1f05
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 0f
tab 0, row 14, @0x1efc
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 10
tab 0, row 15, @0x1ef3
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 11
tab 0, row 16, @0x1eea
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 12
tab 0, row 17, @0x1ee1
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 13
tab 0, row 18, @0x1ed8
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 14
tab 0, row 19, @0x1ecf
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 15
tab 0, row 20, @0x1ec6
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 16
tab 0, row 21, @0x1ebd
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 17
tab 0, row 22, @0x1eb4
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 18
tab 0, row 23, @0x1eab
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 19
tab 0, row 24, @0x1ea2
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 1a
tab 0, row 25, @0x1e99
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 1b
tab 0, row 26, @0x1e90
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 1c
tab 0, row 27, @0x1e87
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 1d
tab 0, row 28, @0x1e7e
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 1e
tab 0, row 29, @0x1e75
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 1f
tab 0, row 30, @0x1e6c
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 20
tab 0, row 31, @0x1e63
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 21
tab 0, row 32, @0x1e5a
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 22
tab 0, row 33, @0x1e51
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 23
tab 0, row 34, @0x1e48
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 24
tab 0, row 35, @0x1e3f
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 25
tab 0, row 36, @0x1e36
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 26
tab 0, row 37, @0x1e2d
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 27
tab 0, row 38, @0x1e24
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 28
tab 0, row 39, @0x1e1b
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 29
tab 0, row 40, @0x1e12
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 2a
tab 0, row 41, @0x1e09
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 2b
tab 0, row 42, @0x1e00
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 2c
tab 0, row 43, @0x1df7
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 2d
tab 0, row 44, @0x1dee
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 2e
tab 0, row 45, @0x1de5
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 2f
tab 0, row 46, @0x1ddc
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 30
tab 0, row 47, @0x1dd3
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 31
tab 0, row 48, @0x1dca
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 32
tab 0, row 49, @0x1bec
tl: 5 fb: --H-FL-- lb: 0x3 cc: 1
col 0: [ 1] 80
tab 0, row 50, @0x1db8
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 34
tab 0, row 51, @0x1daf
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 35
tab 0, row 52, @0x1da6
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 36
tab 0, row 53, @0x1d9d
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 37
tab 0, row 54, @0x1d94
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 38
tab 0, row 55, @0x1d8b
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 39
tab 0, row 56, @0x1d82
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 3a
tab 0, row 57, @0x1d79
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 3b
tab 0, row 58, @0x1d70
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 3c
tab 0, row 59, @0x1d67
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 3d
tab 0, row 60, @0x1d5e
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 3e
tab 0, row 61, @0x1d55
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 3f
tab 0, row 62, @0x1d4c
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 40
tab 0, row 63, @0x1d43
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 41
tab 0, row 64, @0x1d3a
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 42
tab 0, row 65, @0x1d31
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 43
tab 0, row 66, @0x1d28
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 44
tab 0, row 67, @0x1d1f
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 45
tab 0, row 68, @0x1d16
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 46
tab 0, row 69, @0x1d0d
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 47
tab 0, row 70, @0x1d04
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 48
tab 0, row 71, @0x1cfb
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 49
tab 0, row 72, @0x1cf2
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 4a
tab 0, row 73, @0x1ce9
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 4b
tab 0, row 74, @0x1ce0
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 4c
tab 0, row 75, @0x1cd7
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 4d
tab 0, row 76, @0x1cce
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 4e
tab 0, row 77, @0x1cc5
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 4f
tab 0, row 78, @0x1cbc
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 50
tab 0, row 79, @0x1cb3
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 51
tab 0, row 80, @0x1caa
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 52
tab 0, row 81, @0x1ca1
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 53
tab 0, row 82, @0x1c98
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 54
tab 0, row 83, @0x1c8f
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 55
tab 0, row 84, @0x1c86
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 56
tab 0, row 85, @0x1c7d
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 57
tab 0, row 86, @0x1c74
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 58
tab 0, row 87, @0x1c6b
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 59
tab 0, row 88, @0x1c62
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 5a
tab 0, row 89, @0x1c59
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 5b
tab 0, row 90, @0x1c50
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 5c
tab 0, row 91, @0x1c47
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 5d
tab 0, row 92, @0x1c3e
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 5e
tab 0, row 93, @0x1c35
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 5f
tab 0, row 94, @0x1c2c
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 60
tab 0, row 95, @0x1c23
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 61
tab 0, row 96, @0x1c1a
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 62
tab 0, row 97, @0x1c11
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 63
tab 0, row 98, @0x1c08
tl: 6 fb: --H-FL-- lb: 0x0 cc: 1
col 0: [ 2] c1 64
end_of_block_dump
End dump data blocks tsn: 6 file#: 6 minblk 252 maxblk 252

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-17252/,如需轉載,請註明出處,否則將追究法律責任。

相關文章