請教eygle一個問題﹐呵呵﹐打攪了

yangtingkun

用UltraEdite吧，很好用的工具。

eygle

没有那么难吧:

[php]
Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.

C:\Documents and Settings\gqgai>cd\

C:\>net start oracleserviceeygle
OracleServiceEYGLE 服务正在启动 .......................
OracleServiceEYGLE 服务已经启动成功。


C:\>9i

C:\>echo off
Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.

C:\>sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.6.0 - Production on Sat Mar 5 22:39:47 2005

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


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production

22:39:48 SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
----------------------------------------
D:\ORADATA\EYGLE\SYSTEM01.DBF
D:\ORADATA\EYGLE\PERFSTAT01.DBF
D:\ORADATA\EYGLE\EYGLE.DBF
D:\ORADATA\EYGLE\UNDOTBS2.DBF

Elapsed: 00:00:00.02
22:39:53 SQL> create tablespace test
22:39:57   2  datafile 'd:\oradata\eygle\test01.dbf' size 10M;

Tablespace created.

Elapsed: 00:00:02.09
22:40:13 SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
22:40:29 SQL> startup
ORACLE instance started.

Total System Global Area   59842188 bytes
Fixed Size                   454284 bytes
Variable Size              33554432 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes
Database mounted.
Database opened.
22:40:42 SQL> create table test tablespace test as select * from dba_objects;
create table test tablespace test as select * from dba_objects
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object


Elapsed: 00:00:00.03
22:41:05 SQL> create table t tablespace test as select * from dba_objects;

Table created.

Elapsed: 00:00:00.07
22:41:12 SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
22:41:22 SQL> startup
ORACLE instance started.

Total System Global Area   59842188 bytes
Fixed Size                   454284 bytes
Variable Size              33554432 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes
Database mounted.
Database opened.
22:44:21 SQL> select count(*) from t;
select count(*) from t
                     *
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 2, block # 80)
ORA-01110: data file 2: 'D:\ORADATA\EYGLE\TEST01.DBF'


Elapsed: 00:00:00.06
22:44:29 SQL>
.
[/php]


用UltraEdit或者WinHex编辑，用16进制模式。
不能用notepad，存储时会改变格式的。

chenyajun3

建议使用ultraedit，这是一个不错的16进制编辑器。。
刚开始我就是删除了字节，后来才发现应该是修改字节而不是删除。。

kele08

如果打开二进制文件，ultraedit是最适合的，且不会改变文件内容