實驗3：利用BBED工具插入行資料
利用BBED工具恢復刪除的行、直接刪除行比較簡單，而透過BBED插入一行資料相對繁瑣，下面透過實驗演示如何插入一行資料。
SQL> select * from perry ;
ID NAME
---------- ----------
1111 aaaa
2222 bbbb
3333 cccc
--下面實驗將新增一行：ID=4444，NAME=dddd
select dump(4444,16) from dual ;
DUMP(4444,16)
---------------------
Typ=2 Len=3: c2,2d,2d
SQL> select dump('dddd',16) from dual ;
DUMP('DDDD',16)
-------------------------
Typ=96 Len=4: 64,64,64,64
SQL> select dbms_rowid.rowid_object(rowid) object_id,
2 dbms_rowid.rowid_relative_fno(rowid) file_id,
3 dbms_rowid.rowid_block_number(rowid) block_id,
4 dbms_rowid.rowid_row_number(rowid) num
5 from perry ;
OBJECT_ID FILE_ID BLOCK_ID NUM
--------- ---------- ---------- ----------
52512 6 24 0
52512 6 24 1
52512 6 24 2
BBED> set dba 6,24
DBA 0x01800010 (25165840 6,16)
BBED> p kdbr
sb2 kdbr[0] @118 8076
sb2 kdbr[1] @120 8064
sb2 kdbr[2] @122 8052
BBED> p kdbt
struct kdbt[0], 4 bytes @114
b2 kdbtoffs @114 0
b2 kdbtnrow @116 3 --此值修改為4（4行）
BBED> m /x 04 offset 116
Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) y
File: /oradata/susdata/perry01.dbf (6)
Block: 24 Offsets: 116 to 627 Dba:0x01800018
------------------------------------------------------------------------
04008c1f 801f741f 601fc80e 12042004 2e043c04 4a045804 66047404 82049004
9e04ac04 ba04c804 d604e404 f2040005 0e051c05 2a053805 46055405 62057005
7e058c05 9a05a805 b605c405 d205e005 ee05fc05 0a061806 26063406 42065006
5e066c06 7a068806 9606a406 b206c006 ce06db06 e906f706 05071307 21072f07
3d074b07 59076707 75078307 91079f07 ad07bb07 c907d707 e507f307 01080f08
1d082b08 39084708 55086308 71087f08 8d089b08 a908b708 c508d308 e108ef08
fd080b09 19092709 35094309 51095f09 6d097b09 89099709 a409b109 be09cc09
da09e809 f609040a 120a200a 2e0a3c0a 4a0a580a 660a740a 820a900a 9e0aac0a
ba0ac80a d60ae40a f20a000b 0e0b1c0b 2a0b380b 460b540b 620b700b 7e0b8c0b
9a0ba80b b60bc40b d20be00b ee0bfc0b 0a0c180c 260c340c 420c500c 5e0c6c0c
7a0c880c 960ca40c b20cc00c ce0cdc0c ea0cf80c 060d140d 220d300d 3e0d4c0d
5a0d680d 760d840d 920da00d ae0dbc0d ca0dd80d e60df40d 020e100e 1e0e2c0e
3a0e480e 560e640e 720e800e 8e0e9c0e aa0eb80e c60ed40e e20ef00e fe0e0c0f
1a0f280f 360f440f 520f600f 6e0f7c0f 8a0f980f a60fb40f c20fd00f de0fec0f
fa0f0810 16102410 32104010 4e105c10 6a107810 86109410 a210b010 be10cc10
da10e810 f6100411 12112011 2c113811 44115211 60116e11 7c118a11 9811a611
<32 bytes per line>
BBED> p kdbh
struct kdbh, 14 bytes @100
ub1 kdbhflag @100 0x00 (NONE)
b1 kdbhntab @101 1
b2 kdbhnrow @102 3 --此值修改4(4行)
sb2 kdbhfrre @104 -1
sb2 kdbhfsbo @106 24 --修改此值為26=0x1a（新增一行，此值加2（flag+itl））
sb2 kdbhfseo @108 8052 --修改此值為8040=1f68（8052-2-10（增加長度））
b2 kdbhavsp @110 8028 --修改此值為8040-26=8014=1f4e
b2 kdbhtosp @112 8028 --修改此值為1f4e
BBED> m /x 04 offset 102
File: /oradata/susdata/perry01.dbf (6)
Block: 24 Offsets: 102 to 613 Dba:0x01800018
------------------------------------------------------------------------
0400ffff 1800741f 5c1f5c1f 00000400 8c1f801f 741f601f c80e1204 20042e04
3c044a04 58046604 74048204 90049e04 ac04ba04 c804d604 e404f204 00050e05
1c052a05 38054605 54056205 70057e05 8c059a05 a805b605 c405d205 e005ee05
fc050a06 18062606 34064206 50065e06 6c067a06 88069606 a406b206 c006ce06
db06e906 f7060507 13072107 2f073d07 4b075907 67077507 83079107 9f07ad07
bb07c907 d707e507 f3070108 0f081d08 2b083908 47085508 63087108 7f088d08
9b08a908 b708c508 d308e108 ef08fd08 0b091909 27093509 43095109 5f096d09
7b098909 9709a409 b109be09 cc09da09 e809f609 040a120a 200a2e0a 3c0a4a0a
580a660a 740a820a 900a9e0a ac0aba0a c80ad60a e40af20a 000b0e0b 1c0b2a0b
380b460b 540b620b 700b7e0b 8c0b9a0b a80bb60b c40bd20b e00bee0b fc0b0a0c
180c260c 340c420c 500c5e0c 6c0c7a0c 880c960c a40cb20c c00cce0c dc0cea0c
f80c060d 140d220d 300d3e0d 4c0d5a0d 680d760d 840d920d a00dae0d bc0dca0d
d80de60d f40d020e 100e1e0e 2c0e3a0e 480e560e 640e720e 800e8e0e 9c0eaa0e
b80ec60e d40ee20e f00efe0e 0c0f1a0f 280f360f 440f520f 600f6e0f 7c0f8a0f
980fa60f b40fc20f d00fde0f ec0ffa0f 08101610 24103210 40104e10 5c106a10
78108610 9410a210 b010be10 cc10da10 e810f610 04111211 20112c11 38114411
<32 bytes per line>
BBED> m /x 1a offset 106 --26
File: /oradata/susdata/perry01.dbf (6)
Block: 24 Offsets: 106 to 617 Dba:0x01800018
------------------------------------------------------------------------
1a00741f 5c1f5c1f 00000400 8c1f801f 741f601f c80e1204 20042e04 3c044a04
58046604 74048204 90049e04 ac04ba04 c804d604 e404f204 00050e05 1c052a05
38054605 54056205 70057e05 8c059a05 a805b605 c405d205 e005ee05 fc050a06
18062606 34064206 50065e06 6c067a06 88069606 a406b206 c006ce06 db06e906
f7060507 13072107 2f073d07 4b075907 67077507 83079107 9f07ad07 bb07c907
d707e507 f3070108 0f081d08 2b083908 47085508 63087108 7f088d08 9b08a908
b708c508 d308e108 ef08fd08 0b091909 27093509 43095109 5f096d09 7b098909
9709a409 b109be09 cc09da09 e809f609 040a120a 200a2e0a 3c0a4a0a 580a660a
740a820a 900a9e0a ac0aba0a c80ad60a e40af20a 000b0e0b 1c0b2a0b 380b460b
540b620b 700b7e0b 8c0b9a0b a80bb60b c40bd20b e00bee0b fc0b0a0c 180c260c
340c420c 500c5e0c 6c0c7a0c 880c960c a40cb20c c00cce0c dc0cea0c f80c060d
140d220d 300d3e0d 4c0d5a0d 680d760d 840d920d a00dae0d bc0dca0d d80de60d
f40d020e 100e1e0e 2c0e3a0e 480e560e 640e720e 800e8e0e 9c0eaa0e b80ec60e
d40ee20e f00efe0e 0c0f1a0f 280f360f 440f520f 600f6e0f 7c0f8a0f 980fa60f
b40fc20f d00fde0f ec0ffa0f 08101610 24103210 40104e10 5c106a10 78108610
9410a210 b010be10 cc10da10 e810f610 04111211 20112c11 38114411 52116011
<32 bytes per line>
BBED> m /x 681f offset 108 --8040
File: /oradata/susdata/perry01.dbf (6)
Block: 24 Offsets: 108 to 619 Dba:0x01800018
------------------------------------------------------------------------
681f5c1f 5c1f0000 04008c1f 801f741f 601fc80e 12042004 2e043c04 4a045804
66047404 82049004 9e04ac04 ba04c804 d604e404 f2040005 0e051c05 2a053805
46055405 62057005 7e058c05 9a05a805 b605c405 d205e005 ee05fc05 0a061806
26063406 42065006 5e066c06 7a068806 9606a406 b206c006 ce06db06 e906f706
05071307 21072f07 3d074b07 59076707 75078307 91079f07 ad07bb07 c907d707
e507f307 01080f08 1d082b08 39084708 55086308 71087f08 8d089b08 a908b708
c508d308 e108ef08 fd080b09 19092709 35094309 51095f09 6d097b09 89099709
a409b109 be09cc09 da09e809 f609040a 120a200a 2e0a3c0a 4a0a580a 660a740a
820a900a 9e0aac0a ba0ac80a d60ae40a f20a000b 0e0b1c0b 2a0b380b 460b540b
620b700b 7e0b8c0b 9a0ba80b b60bc40b d20be00b ee0bfc0b 0a0c180c 260c340c
420c500c 5e0c6c0c 7a0c880c 960ca40c b20cc00c ce0cdc0c ea0cf80c 060d140d
220d300d 3e0d4c0d 5a0d680d 760d840d 920da00d ae0dbc0d ca0dd80d e60df40d
020e100e 1e0e2c0e 3a0e480e 560e640e 720e800e 8e0e9c0e aa0eb80e c60ed40e
e20ef00e fe0e0c0f 1a0f280f 360f440f 520f600f 6e0f7c0f 8a0f980f a60fb40f
c20fd00f de0fec0f fa0f0810 16102410 32104010 4e105c10 6a107810 86109410
a210b010 be10cc10 da10e810 f6100411 12112011 2c113811 44115211 60116e11
<32 bytes per line>
BBED> m /x 4e1f offset 110 --8014
File: /oradata/susdata/perry01.dbf (6)
Block: 24 Offsets: 110 to 621 Dba:0x01800018
------------------------------------------------------------------------
4e1f5c1f 00000400 8c1f801f 741f601f c80e1204 20042e04 3c044a04 58046604
74048204 90049e04 ac04ba04 c804d604 e404f204 00050e05 1c052a05 38054605
54056205 70057e05 8c059a05 a805b605 c405d205 e005ee05 fc050a06 18062606
34064206 50065e06 6c067a06 88069606 a406b206 c006ce06 db06e906 f7060507
13072107 2f073d07 4b075907 67077507 83079107 9f07ad07 bb07c907 d707e507
f3070108 0f081d08 2b083908 47085508 63087108 7f088d08 9b08a908 b708c508
d308e108 ef08fd08 0b091909 27093509 43095109 5f096d09 7b098909 9709a409
b109be09 cc09da09 e809f609 040a120a 200a2e0a 3c0a4a0a 580a660a 740a820a
900a9e0a ac0aba0a c80ad60a e40af20a 000b0e0b 1c0b2a0b 380b460b 540b620b
700b7e0b 8c0b9a0b a80bb60b c40bd20b e00bee0b fc0b0a0c 180c260c 340c420c
500c5e0c 6c0c7a0c 880c960c a40cb20c c00cce0c dc0cea0c f80c060d 140d220d
300d3e0d 4c0d5a0d 680d760d 840d920d a00dae0d bc0dca0d d80de60d f40d020e
100e1e0e 2c0e3a0e 480e560e 640e720e 800e8e0e 9c0eaa0e b80ec60e d40ee20e
f00efe0e 0c0f1a0f 280f360f 440f520f 600f6e0f 7c0f8a0f 980fa60f b40fc20f
d00fde0f ec0ffa0f 08101610 24103210 40104e10 5c106a10 78108610 9410a210
b010be10 cc10da10 e810f610 04111211 20112c11 38114411 52116011 6e117c11
<32 bytes per line>
BBED> m /x 4e1f offset 112 --8014
File: /oradata/susdata/perry01.dbf (6)
Block: 24 Offsets: 112 to 623 Dba:0x01800018
------------------------------------------------------------------------
4e1f0000 04008c1f 801f741f 601fc80e 12042004 2e043c04 4a045804 66047404
82049004 9e04ac04 ba04c804 d604e404 f2040005 0e051c05 2a053805 46055405
62057005 7e058c05 9a05a805 b605c405 d205e005 ee05fc05 0a061806 26063406
42065006 5e066c06 7a068806 9606a406 b206c006 ce06db06 e906f706 05071307
21072f07 3d074b07 59076707 75078307 91079f07 ad07bb07 c907d707 e507f307
01080f08 1d082b08 39084708 55086308 71087f08 8d089b08 a908b708 c508d308
e108ef08 fd080b09 19092709 35094309 51095f09 6d097b09 89099709 a409b109
be09cc09 da09e809 f609040a 120a200a 2e0a3c0a 4a0a580a 660a740a 820a900a
9e0aac0a ba0ac80a d60ae40a f20a000b 0e0b1c0b 2a0b380b 460b540b 620b700b
7e0b8c0b 9a0ba80b b60bc40b d20be00b ee0bfc0b 0a0c180c 260c340c 420c500c
5e0c6c0c 7a0c880c 960ca40c b20cc00c ce0cdc0c ea0cf80c 060d140d 220d300d
3e0d4c0d 5a0d680d 760d840d 920da00d ae0dbc0d ca0dd80d e60df40d 020e100e
1e0e2c0e 3a0e480e 560e640e 720e800e 8e0e9c0e aa0eb80e c60ed40e e20ef00e
fe0e0c0f 1a0f280f 360f440f 520f600f 6e0f7c0f 8a0f980f a60fb40f c20fd00f
de0fec0f fa0f0810 16102410 32104010 4e105c10 6a107810 86109410 a210b010
be10cc10 da10e810 f6100411 12112011 2c113811 44115211 60116e11 7c118a11
<32 bytes per line>
BBED> p kdbh
struct kdbh, 14 bytes @100
ub1 kdbhflag @100 0x00 (NONE)
b1 kdbhntab @101 1
b2 kdbhnrow @102 4
sb2 kdbhfrre @104 -1
sb2 kdbhfsbo @106 26
sb2 kdbhfseo @108 8040
b2 kdbhavsp @110 8014
b2 kdbhtosp @112 8014
BBED> p kdbr --可以看到已經新增一行
sb2 kdbr[0] @118 8076
sb2 kdbr[1] @120 8064
sb2 kdbr[2] @122 8052
sb2 kdbr[3] @124 8032 --此值修改為8040=0x1f68（kdbhfseo）
BBED> m /x 681f offset 124 --8040
File: /oradata/susdata/perry01.dbf (6)
Block: 24 Offsets: 124 to 635 Dba:0x01800018
------------------------------------------------------------------------
681fc80e 12042004 2e043c04 4a045804 66047404 82049004 9e04ac04 ba04c804
d604e404 f2040005 0e051c05 2a053805 46055405 62057005 7e058c05 9a05a805
b605c405 d205e005 ee05fc05 0a061806 26063406 42065006 5e066c06 7a068806
9606a406 b206c006 ce06db06 e906f706 05071307 21072f07 3d074b07 59076707
75078307 91079f07 ad07bb07 c907d707 e507f307 01080f08 1d082b08 39084708
55086308 71087f08 8d089b08 a908b708 c508d308 e108ef08 fd080b09 19092709
35094309 51095f09 6d097b09 89099709 a409b109 be09cc09 da09e809 f609040a
120a200a 2e0a3c0a 4a0a580a 660a740a 820a900a 9e0aac0a ba0ac80a d60ae40a
f20a000b 0e0b1c0b 2a0b380b 460b540b 620b700b 7e0b8c0b 9a0ba80b b60bc40b
d20be00b ee0bfc0b 0a0c180c 260c340c 420c500c 5e0c6c0c 7a0c880c 960ca40c
b20cc00c ce0cdc0c ea0cf80c 060d140d 220d300d 3e0d4c0d 5a0d680d 760d840d
920da00d ae0dbc0d ca0dd80d e60df40d 020e100e 1e0e2c0e 3a0e480e 560e640e
720e800e 8e0e9c0e aa0eb80e c60ed40e e20ef00e fe0e0c0f 1a0f280f 360f440f
520f600f 6e0f7c0f 8a0f980f a60fb40f c20fd00f de0fec0f fa0f0810 16102410
32104010 4e105c10 6a107810 86109410 a210b010 be10cc10 da10e810 f6100411
12112011 2c113811 44115211 60116e11 7c118a11 9811a611 b411c211 d011de11
<32 bytes per line>
BBED> p kdbr
sb2 kdbr[0] @118 8076
sb2 kdbr[1] @120 8064
sb2 kdbr[2] @122 8052
sb2 kdbr[3] @124 8040
BBED> p rowdata --下面開始修改行資料
ub1 rowdata[0] @8140 0x1d --2c
ub1 rowdata[1] @8141 0x34 --00
ub1 rowdata[2] @8142 0x80 --02
ub1 rowdata[3] @8143 0x00 --03
ub1 rowdata[4] @8144 0x0b --c2
ub1 rowdata[5] @8145 0x01 --2d
ub1 rowdata[6] @8146 0x12 --2d
ub1 rowdata[7] @8147 0x00 --04
ub1 rowdata[8] @8148 0x00 --64
ub1 rowdata[9] @8149 0x00 --64
ub1 rowdata[10] @8150 0x50 --64
ub1 rowdata[11] @8151 0x00 --64
ub1 rowdata[12] @8152 0x2c
ub1 rowdata[13] @8153 0x01
ub1 rowdata[14] @8154 0x02
ub1 rowdata[15] @8155 0x03
ub1 rowdata[16] @8156 0xc2
ub1 rowdata[17] @8157 0x22
ub1 rowdata[18] @8158 0x22
ub1 rowdata[19] @8159 0x04
ub1 rowdata[20] @8160 0x63
ub1 rowdata[21] @8161 0x63
ub1 rowdata[22] @8162 0x63
ub1 rowdata[23] @8163 0x63
ub1 rowdata[24] @8164 0x2c
ub1 rowdata[25] @8165 0x01
ub1 rowdata[26] @8166 0x02
ub1 rowdata[27] @8167 0x03
ub1 rowdata[28] @8168 0xc2
ub1 rowdata[29] @8169 0x17
ub1 rowdata[30] @8170 0x17
ub1 rowdata[31] @8171 0x04
ub1 rowdata[32] @8172 0x62
ub1 rowdata[33] @8173 0x62
ub1 rowdata[34] @8174 0x62
ub1 rowdata[35] @8175 0x62
ub1 rowdata[36] @8176 0x2c
ub1 rowdata[37] @8177 0x01
ub1 rowdata[38] @8178 0x02
ub1 rowdata[39] @8179 0x03
ub1 rowdata[40] @8180 0xc2
ub1 rowdata[41] @8181 0x0c
ub1 rowdata[42] @8182 0x0c
ub1 rowdata[43] @8183 0x04
ub1 rowdata[44] @8184 0x61
ub1 rowdata[45] @8185 0x61
ub1 rowdata[46] @8186 0x61
ub1 rowdata[47] @8187 0x61
BBED> m /x 2c offset 8140 --此處offset=8040+100(塊頭)=8140
File: /oradata/susdata/perry01.dbf (6)
Block: 24 Offsets: 8140 to 8191 Dba:0x01800018
------------------------------------------------------------------------
2c348000 0b011200 00005000 2c010203 c2222204 63636363 2c010203 c2171704
62626262 2c010203 c20c0c04 61616161 0106fd4f
<32 bytes per line>
BBED> m /x 00 offset 8141
File: /oradata/susdata/perry01.dbf (6)
Block: 24 Offsets: 8141 to 8191 Dba:0x01800018
------------------------------------------------------------------------
0080000b 01120000 0050002c 010203c2 22220463 6363632c 010203c2 17170462
6262622c 010203c2 0c0c0461 61616101 06fd4f
<32 bytes per line>
BBED> m /x 02 offset 8142
File: /oradata/susdata/perry01.dbf (6)
Block: 24 Offsets: 8142 to 8191 Dba:0x01800018
------------------------------------------------------------------------
02000b01 12000000 50002c01 0203c222 22046363 63632c01 0203c217 17046262
62622c01 0203c20c 0c046161 61610106 fd4f
<32 bytes per line>
BBED> m /x 03 offset 8143
File: /oradata/susdata/perry01.dbf (6)
Block: 24 Offsets: 8143 to 8191 Dba:0x01800018
------------------------------------------------------------------------
030b0112 00000050 002c0102 03c22222 04636363 632c0102 03c21717 04626262
622c0102 03c20c0c 04616161 610106fd 4f
<32 bytes per line>
BBED> m /x c22d2d offset 8144
File: /oradata/susdata/perry01.dbf (6)
Block: 24 Offsets: 8144 to 8191 Dba:0x01800018
------------------------------------------------------------------------
c22d2d00 00005000 2c010203 c2222204 63636363 2c010203 c2171704 62626262
2c010203 c20c0c04 61616161 0106fd4f
<32 bytes per line>
BBED> m /x 04 offset 8147
File: /oradata/susdata/perry01.dbf (6)
Block: 24 Offsets: 8147 to 8191 Dba:0x01800018
------------------------------------------------------------------------
04000050 002c0102 03c22222 04636363 632c0102 03c21717 04626262 622c0102
03c20c0c 04616161 610106fd 4f
<32 bytes per line>
BBED> m /x 64646464 offset 8148
File: /oradata/susdata/perry01.dbf (6)
Block: 24 Offsets: 8148 to 8191 Dba:0x01800018
------------------------------------------------------------------------
64646464 2c010203 c2222204 63636363 2c010203 c2171704 62626262 2c010203
c20c0c04 61616161 0106fd4f
BBED> p rowdata
ub1 rowdata[0] @8140 0x2c
ub1 rowdata[1] @8141 0x00
ub1 rowdata[2] @8142 0x02
ub1 rowdata[3] @8143 0x03
ub1 rowdata[4] @8144 0xc2
ub1 rowdata[5] @8145 0x2d
ub1 rowdata[6] @8146 0x2d
ub1 rowdata[7] @8147 0x04
ub1 rowdata[8] @8148 0x64
ub1 rowdata[9] @8149 0x64
ub1 rowdata[10] @8150 0x64
ub1 rowdata[11] @8151 0x64
ub1 rowdata[12] @8152 0x2c
ub1 rowdata[13] @8153 0x01
ub1 rowdata[14] @8154 0x02
ub1 rowdata[15] @8155 0x03
ub1 rowdata[16] @8156 0xc2
ub1 rowdata[17] @8157 0x22
ub1 rowdata[18] @8158 0x22
ub1 rowdata[19] @8159 0x04
ub1 rowdata[20] @8160 0x63
ub1 rowdata[21] @8161 0x63
ub1 rowdata[22] @8162 0x63
ub1 rowdata[23] @8163 0x63
ub1 rowdata[24] @8164 0x2c
ub1 rowdata[25] @8165 0x01
ub1 rowdata[26] @8166 0x02
ub1 rowdata[27] @8167 0x03
ub1 rowdata[28] @8168 0xc2
ub1 rowdata[29] @8169 0x17
ub1 rowdata[30] @8170 0x17
ub1 rowdata[31] @8171 0x04
ub1 rowdata[32] @8172 0x62
ub1 rowdata[33] @8173 0x62
ub1 rowdata[34] @8174 0x62
ub1 rowdata[35] @8175 0x62
ub1 rowdata[36] @8176 0x2c
ub1 rowdata[37] @8177 0x01
ub1 rowdata[38] @8178 0x02
ub1 rowdata[39] @8179 0x03
ub1 rowdata[40] @8180 0xc2
ub1 rowdata[41] @8181 0x0c
ub1 rowdata[42] @8182 0x0c
ub1 rowdata[43] @8183 0x04
ub1 rowdata[44] @8184 0x61
ub1 rowdata[45] @8185 0x61
ub1 rowdata[46] @8186 0x61
ub1 rowdata[47] @8187 0x61
BBED> sum apply
Check value for File 6, Block 24:
current = 0xbe77, required = 0xbe77
BBED> verify
DBVERIFY - Verification starting
FILE = /oradata/susdata/perry01.dbf
BLOCK = 24
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 1
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 0
Total Blocks Failing (Index): 0
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
SQL> alter system flush buffer_cache; --重新整理快取
系統已更改。
SQL> select * from perry ;
ID NAME
---------- ----------
1111 aaaa
2222 bbbb
3333 cccc
4444 dddd
至此，新的資料行插入成功。
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26008584/viewspace-1256911/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 實驗2：利用BBED工具刪除行資料
- 實驗1：利用BBED工具恢復刪除的資料行
- ORACLE空間管理實驗8：資料塊格式分析--DUMP結合BBEDOracle
- 【BBED】使用bbed修改數字型別資料型別
- 【BBED】使用bbed修改字元型別資料字元型別
- 利用BBED修改資料塊SCN----極端環境下的資料恢復資料恢復
- BBED (Oracle Block Brower and EDitor Tool) ：資料塊修復工具OracleBloC
- 實驗二 插值方法(android)Android
- 【BBED】使用bbed 修改日期型別的資料型別
- 利用Cluster Verify Utility工具體驗RAC最佳實踐
- Oracle 之利用BBED修改資料塊SCN----沒有備份資料檔案的資料恢復Oracle資料恢復
- 27_bbed實戰(1)_修改資料內容
- 資料庫實驗3 資料定義語言DDL資料庫
- 利用fiddler工具，mock介面資料Mock
- 利用rman做資料檔案丟失的恢復實驗
- 【BBED】使用bbed恢復已經刪除的行資料
- 資料庫實驗2 掌握DBMS常用工具資料庫
- 利用Dawn工程化工具實踐MobX資料流管理方案
- Oracle BBED 工具介紹Oracle
- Oracle BBED 工具 說明Oracle
- Oracle bbed工具的使用Oracle
- Oracle BBED 工具說明Oracle
- oracle資料庫插入行更快方法Oracle資料庫
- bbed_recover:恢復資料塊資料庫資料庫
- bbed 之資料修改Ktbbh(Ktbbh資料)
- 從思路到工具 - 增長實驗資料歸因分析
- oracle bbed修改資料塊的例子Oracle
- oracle資料檔案驗證工具Oracle
- 使用BBED修改檔案頭解決資料庫Open驗證問題（下）資料庫
- 使用BBED修改檔案頭解決資料庫Open驗證問題（上）資料庫
- --bbed_recover:恢復資料塊資料庫（mybbed）資料庫
- bbed_recover:恢復資料塊資料庫(續)資料庫
- 資料怎麼插不進去（資料庫）？資料庫
- [20210319]bbed讀取資料塊3.txt
- 【實驗】利用可傳輸表空間技術實現資料的高效遷移
- 資料所在的資料塊實驗
- 實驗3
- 利用 canvas 實現資料壓縮Canvas