-
编辑 删除
ORA-01114: IO error writing block to file
今天同事在qq上问我，怎么查找一个block属于哪个file，感觉很奇怪，就让他把报错信息发出来。ORA-01114: IO error writing block to file 1001 (block # 1397385)ORA-27063: number of bytes read/written is incor...
-
编辑 删除
分析表时引发的一个ora-600 [qkssao2s1]
SQL> create table test as select * from dba_objects;Table createdSQL> create index test_object_id on test(object_id);Index createdSQL> create index test_data_object_id on test(data_object_id,1);-...
-
编辑 删除
exp does not support binary_float or binary_double
SQL> select * from v$version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64biPL/SQL Release 10.2.0.1.0 - Productio...
-
编辑 删除
ORA-01775与ORA-00942
在系统易用中，经常使用synonym，以便于管理或者权限控制。因此会经常遇到ORA-01775: 同义词的循环链oracle的解释是这样的：ORA-01775: looping chain of synonyms Cause: Through a series of CREATE synonym state...
-
编辑 删除
TNS-12549,TNS-12560,TNS-00519,Linux Error: 28: No space left on device
作者提出的问题是这样的：一台测试的服务器，停电再起来后发现listener起不来，报错如下：Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.191.100)(PORT=1521)))Error listening on: (ADDRESS=(P...
