I had a data block corruption error on a table and used dbms_repair to mark the blocks corrupt and skip them in the future. There were some index errors as well, so I rebuit all the indexes for this table. Now everything seems to be working fine, except that I get an error when I try to run the "analyze table validate structure online" command. I want to run this command in order to ensure that the block corruption has indeed been fixed.
BTW, when this error comes up, I also lose my connection and have to reconnect in sqlplus.
SQL>analyze table tablename validate structure online;
ERROR at line 1:
ORA-03113: end-of-file on communication channel