你好,游客 登录 注册 搜索
背景:
阅读新闻

Oracle数据块详解

[日期:2012-07-15] 来源:Linux社区  作者:wolf [字体: ]

下面我们来看看这个数据块

dump说明
创建表空间和测试表:
create tablespace testblock datafile '/opt/app/Oracle/oradata/wolf/testblock01.dbf' size 100M;
create table testblock(
id number,
name varchar(4)
) tablespace testblock;
插入3条数据然后提交:
SQL> insert into testblock values(1,'a');
SQL> insert into testblock values(2,'b');
SQL> insert into testblock values(3,'c');
SQL> commit;
SQL> select * from testblock;
        ID NAME
---------- --------
         1 a
         2 b
         3 c

SQL> commit

SQL> desc V$datafile;

 Name                                      Null?    Type

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

 FILE#                                              NUMBER

 CREATION_CHANGE#                                   NUMBER

 CREATION_TIME                                      DATE

 TS#                                                NUMBER

 RFILE#                                             NUMBER

 STATUS                                             VARCHAR2(7)

 ENABLED                                            VARCHAR2(10)

 CHECKPOINT_CHANGE#                                 NUMBER

 CHECKPOINT_TIME                                    DATE

 UNRECOVERABLE_CHANGE#                              NUMBER

 UNRECOVERABLE_TIME                                 DATE

 LAST_CHANGE#                                       NUMBER

 LAST_TIME                                          DATE

 OFFLINE_CHANGE#                                    NUMBER

 ONLINE_CHANGE#                                     NUMBER

 ONLINE_TIME                                        DATE

 BYTES                                              NUMBER

 BLOCKS                                             NUMBER

 CREATE_BYTES                                       NUMBER

 BLOCK_SIZE                                         NUMBER

 NAME                                               VARCHAR2(513)

 PLUGGED_IN                                         NUMBER

 BLOCK1_OFFSET                                      NUMBER

 AUX_NAME                                           VARCHAR2(513)

 FIRST_NONLOGGED_SCN                                NUMBER

 FIRST_NONLOGGED_TIME                               DATE

 

SQL> select FILE#,name from v$datafile;

 

     FILE#

----------

NAME

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

         1

/opt/app/oracle/oradata/wolf/system01.dbf

 

         2

/opt/app/oracle/oradata/wolf/undotbs01.dbf

 

         3

/opt/app/oracle/oradata/wolf/sysaux01.dbf

 

 

     FILE#

----------

NAME

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

         4

/opt/app/oracle/oradata/wolf/users01.dbf

 

         5

/opt/app/oracle/oradata/wolf/testblock01.dbf

 

SQL> select rowid,dbms_rowid.rowid_relative_fno(rowid) rel_fno,dbms_rowid.rowid_block_number(rowid)

blockno from testblock;

  2 

ROWID                 REL_FNO    BLOCKNO

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

AAAMixAAFAAAAAMAAA          5         12

AAAMixAAFAAAAAMAAB          5         12

AAAMixAAFAAAAAMAAC          5         12

SQL> alter system dump datafile 5 block 12;

SQL> show parameter dump;

查找dumping文件位置

linux
相关资讯       Oracle数据块 
本文评论   查看全部评论 (0)
表情: 表情 姓名: 字数

       

评论声明
  • 尊重网上道德,遵守中华人民共和国的各项有关法律法规
  • 承担一切因您的行为而直接或间接导致的民事或刑事法律责任
  • 本站管理人员有权保留或删除其管辖留言中的任意内容
  • 本站有权在网站内转载或引用您的评论
  • 参与本评论即表明您已经阅读并接受上述条款