bbed亲身体会，查看block format

今天在www.dbsnake.com 上看到“关于9i以后block format的含义”的文章，在本机上进行了测试。测试过程如下：

C:Documents and SettingsAdministrator>sqlplus / as sysdba

SYS@kuqlan10>create table t8k tablespace users as select * from dba_users;

表已创建。

SYS@kuqlan10>alter system checkpoint;

系统已更改。

SYS@kuqlan10>select dbms_rowid.rowid_relative_fno(rowid)||'_'||dbms_rowid.rowid_

block_number(rowid) location from t8k where rownum<2;

LOCATION

--------------------------------------------------------------------------------

4_2644

[@more@]

通过cmd打开另外一个窗口，具体执行步骤如下：

C:bbed>bbed parfile=par10g.txt

口令:

BBED: Release 2.0.0.0.0 - Limited Production on 星期六 7月 16 02:03:39 2011

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

************* !!! For Oracle Internal Use only !!! ***************

BBED> set file 4 block 2644

FILE# 4

BLOCK# 2644

BBED> dump

File: F:ORACLEORADATAKUQLAN10USERS01.DBF (4)

Block: 2644 Offsets: 0 to 511 Dba:0x01000a54

------------------------------------------------------------------------

23a20000 530a0001 e7070d00 00000104 30600000 00000000 00000000 00000000

00000000 01000000 08000000 9c0a0000 00000000 04000000 08000000 550a0001

00000000 00000000 00000000 04000000 00000000 00000000 00000000 00000000

04000000 08000000 550a0001 00000000 00000000 00000000 04000000 510a0001

510a0001 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 01000000 00200000 00000000 34140000

00000000 520a0001 01000000 510a0001 520a0001 00000000 00000000 00000000

00000000 00000000 01000000 00000000 b2cb0000 00000010 510a0001 08000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

<32 bytes per line>

BBED> p kcbh

BBED-00400: invalid blocktype (35)

BBED> p kcbh

BBED-00400: invalid blocktype (35)

BBED> p kcbh

BBED-00400: invalid blocktype (35)

Block format有了直观认识，但是不知后面的BBED-00400: invalid blocktype (35)错误是怎么排除？

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/18841027/viewspace-1052545/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/18841027/viewspace-1052545/