bbed可以直接查看或修改数据文件,听起来很强大,下面体验一下,安装方法网上一搜一大把,我的环境是centos+10G的
bbed参考文档:http://pan.baidu.com/s/1hqCC6pu
--测试之前,已经创建了ms1用户和表空间mssm
create tablespace mssm
datafile ''/u01/oracle/oradata/gname/mssm.dbf
size 50M
extent management local
segment space management manual;
create user ms1 identified by ms1 default tablespace mssm;
[oracle@111 sql]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jul 4 15:32:23 2014
Copyright (c) 1982, 2005,
Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> conn ms1/ms1
Connected.
SQL> insert into t values(1,'a');
1 row created.
SQL> insert into t values(2,'b');
1 row created.
SQL> insert into t values(999,'seven');
1 row created.
SQL> commit;
Commit complete.
SQL> get getrowidinfo
1 select
2 t.*,
3 --rowid,
4 dbms_rowid.rowid_type(rowid) rowid_type,
5 dbms_rowid.rowid_relative_fno(rowid) file_no,
6 dbms_rowid.rowid_block_number(rowid) block_no,
7 dbms_rowid.rowid_row_number(rowid) row_no,
8 ora_rowscn,
9 dbms_rowid.rowid_object(rowid) object_no
10* from &owner..&table t;
SQL> @getrowidinfo
Enter value for owner: ms1
Enter value for table: t
old 8: from &owner..&table
new 8: from ms1.t
RN ROWID_TYPE FILE_NO BLOCK_NO ROW_NO ORA_ROWSCN OBJECT_NO
---------- ---------- ---------- ---------- ---------- ---------- ----------
1 1 7 10 0 506534 52503
2 1 7 10 1 506534 52503
3 1 7 10 2 506534 52503
SQL> select DEFAULT_TABLESPACE from dba_users where username=user;
DEFAULT_TABLESPACE
------------------------------------------------------------
MSSM
SQL> @getfile
FILE_ID FILE_NAME TABLESPACE_NAME M
---------- -------------------------------------------------- -------------------- ----------
5 /u01/oracle/oradata/gname/example01.dbf EXAMPLE 100
7 /u01/oracle/oradata/gname/mssm.dbf MSSM 50
3 /u01/oracle/oradata/gname/sysaux01.dbf SYSAUX 240
1 /u01/oracle/oradata/gname/system01.dbf SYSTEM 480
6 /u01/oracle/oradata/gname/tab.dbf TAB 100
2 /u01/oracle/oradata/gname/undotbs01.dbf UNDOTBS1 30
4 /u01/oracle/oradata/gname/users01.dbf USERS 5
[oracle@111 sql]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jul 4 16:42:51 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
[oracle@111 sql]$ cp /u01/oracle/oradata/gname/mssm.dbf /u01/oracle/oradata/gname/mssm.dbf_bak20140704
[oracle@111 sql]$ ll /u01/oracle/oradata/gname/mssm*
-rw-r-----. 1 oracle oinstall 52436992 Jul 4 16:44 /u01/oracle/oradata/gname/mssm.dbf
-rw-r-----. 1 oracle oinstall 52436992 Jul 4 16:45 /u01/oracle/oradata/gname/mssm.dbf_bak20140704
SQL> select file#||' '||name||' '||bytes from v$datafile ;
FILE#||''||NAME||''||BYTES
--------------------------------------------------------------------------------
1 /u01/oracle/oradata/gname/system01.dbf 503316480
2 /u01/oracle/oradata/gname/undotbs01.dbf 31457280
3 /u01/oracle/oradata/gname/sysaux01.dbf 251658240
4 /u01/oracle/oradata/gname/users01.dbf 5242880
5 /u01/oracle/ora