Os - windows 7
Database version - oracle 10.2.0.1.0
Database in no archive log mode
i got the following errors at the time of select records from some table,
same error at the time of export backup,
i try dbms_repair.check_object, but same errors message
Plz help me to resolve it.
SQL> select count(*) from abc.party_mas;
select count(*) from abc.party_mas
ERROR at line 1:
ORA-01115: IO error reading block from file 6 (block # 30297)
ORA-01110: data file 6: 'H:\ORACLE\PRODUCT\10.2.0\ORADATA\ORACLE\ABC_DATA.DAT'
ORA-27091: unable to queue I/O
ORA-27070: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 23) Data error (cyclic redundancy check).
thanks in advance
thanks sb92075 for quick reply,
but i can access records from some table the error occurred at the time when i select from some tables only , so how can we say that Device on which the file resides is probably offline,
correct me if i am wrong.
you do not have to convince me of anything.
The issue is between you & the OS.
errors are thrown because a problem exists; whether you acknowledge it or not.
i totally agree with you sir,
i just ask about device offline because may be i cant understand it properly as i am newbie .
i also checked the hardware storage disk by os check disk utility but can't find any solution.
Let me now search on net for this type os error,
some one help me if they have any solution for this type of os error,
and thanks sb92075 for your support and help.