Has the file been deleted by accident? - not sure but this might be the problem - if so DO NOT shutdown or reboot - export the tablespace. 2008/11/3 Dba DBA <oracledbaquestions@xxxxxxxxx> > it happens when i try to create an index or run dbms_repair. > > On Mon, Nov 3, 2008 at 1:59 PM, Rich Jesse < > rjoralist@xxxxxxxxxxxxxxxxxxxxx> wrote: > >> Or your backups are not configured correctly and are attempting to backup >> your live datafiles (which is useless for recovery) and/or are locking >> files >> as they are backed up. >> >> Your SysAdmin should be able to check the Event log to confirm/deny the >> hardware theory. >> >> GL! >> >> Rich >> >> > i googled this. this looks like a hardware issue right? >> > >> > ERROR at line 1: >> > ORA-01115: IO error reading block from file 12 (block # 546933) >> > ORA-01110: data file 12: >> > 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\CCDEV\USERS02.DBF' >> > 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 121) The semaphore timeout period has expired. >> > ORA-06512: at "SYS.DBMS_REPAIR", line 293 >> > ORA-06512: at line 1 >> > >> >> >> -- >> //www.freelists.org/webpage/oracle-l >> >> >> > -- Howard A. Latham