ITPub博客

首页 > IT职业 > IT生活 > bbed亲身体会,查看block format

bbed亲身体会,查看block format

原创 IT生活 作者:kuqlan 时间:2011-07-16 02:32:56 0 删除 编辑

今天在 上看到“关于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博客 ” ,链接:https://blog.itpub.net/18841027/viewspace-1052545/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
Oracle技术爱好者,Oracle10g OCM,网名 KUQLAN ,具有7的年Oracle数据库管理实践,曾经参加过BOSS、ERP、云计算(OpenStack+kvm)等项目的一线工作。以前写博客是为了自己,而现在是为了自己和别人。因为领会了帮助别人和分享、沉淀和积累会创造快乐和价值...

注册时间:2009-01-26

  • 博文量
    183
  • 访问量
    1681009