Error message during count [message #19159] |
Sun, 03 March 2002 23:36 |
Zurina Zainudin
Messages: 2 Registered: March 2002
|
Junior Member |
|
|
I have problem during count statement. Can someone who are expert explain to me how to solve my problem ?.
Errors as followed
ORA - 00115 : 10 error reading block from file 2<block#68829>
ORA - 01110 : data file 2 : 'D:DATABASEPPGLNMSDATAPPG_A.DAT'
ORA - 09206 : sfrfb : error reading file
OSD - 04006 : Readfile<> failure, unable to read from file
O/S - Error : (OS.23) The system could not find the environmnet option that was entered
|
|
|
|
|
|
Re: Error message during count [message #19214 is a reply to message #19159] |
Tue, 05 March 2002 09:50 |
Grant
Messages: 578 Registered: January 2002
|
Senior Member |
|
|
Your data file could very well be corrupt. The reason it works on one table and not the other could be that you are not hitting the bad spot on that table or it is in another datafile associated with that tablespace. I would suggest you shutdown the database and run scandisk at the OS level and dbverify (dbv) on all datafiles.
You may want to run this in sqlplus and verify all your data files. This will create a batch file for you:
set serveroutput on
set echo off
set head off
set pages 0
set feedback off
set linesize 100
spool dbv.sh
select 'dbv '||' file='||file_name||' feedback=300'||' BLOCKSIZE='||value
from dba_data_files, v$parameter
where v$parameter.name = 'db_block_size';
spool off;
|
|
|