Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ora 01115 error

ora 01115 error

From: <slandry_at_hibernia.com>
Date: Tue, 14 Aug 2001 18:51:10 GMT
Message-ID: <3b79730b.106335452@10.16.35.52> 





I have a table that has 1.7 million rows in and am trying to add a not
null column. It runs for about half an hour and I get an error: ora
0115 IO error reading block from file (block # ). It does not display
any block number or file number. Everything is online and all the data
files are under 2G. any ideas on why I am getting this or how to
resolve this? Oracle 8.0.5 AIX version 4.33. 



Thanks,



Sanjana
Received on Tue Aug 14 2001 - 13:51:10 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US