ITPub博客

首页 > Linux操作系统 > Linux操作系统 > dd命令的使用

dd命令的使用

原创 Linux操作系统 作者:q418441117 时间:2012-10-16 22:21:55 0 删除 编辑

SQL> create user hm identified by hm;

User created.

SQL> grant dba to hm;

Grant succeeded.

SQL> SELECT username,default_tablespace FROM DBA_USERS where username='HM';

USERNAME                       DEFAULT_TABLESPACE
------------------------------ ------------------------------
HM                             USERS

SQL> conn hm/hm;
Connected.
SQL> create table fruit(name varchar2(32));

Table created.

SQL> insert into fruit values('orange');

1 row created.

SQL> commit;

Commit complete.

SQL> alter system switch logfile;

System altered.

SQL> select * from fruit;

NAME
--------------------------------
orange

SQL> select dbms_rowid.rowid_block_number(rowid) blk,name from fruit;

       BLK NAME
---------- --------------------------------
       772 orange

SQL> show parameter block;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_block_buffers                     integer     0
db_block_checking                    string      FALSE
db_block_checksum                    string      TRUE
db_block_size                        integer     8192
db_file_multiblock_read_count        integer     16

[oracle@localhost XUHM]$ dd if=users01.dbf ibs=8192 skip=771 count=1 |strings
1+0 records in
16+0 records out
8192 bytes (8.2 kB) copied, 6.5e-05 seconds, 126 MB/s
[oracle@localhost XUHM]$ dd if=users01.dbf ibs=8192 skip=771 count=2 |strings
2+0 records in
32+0 records out
16384 bytes (16 kB) copied, 0.00013 seconds, 126 MB/s
orange

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

请登录后发表评论 登录
全部评论

注册时间:2012-09-11

  • 博文量
    203
  • 访问量
    471922