Hi All,
Due to some reason(not know yet), one of the datafile went offline and cannot be bought offile as the file header is corrupt and does not match with control file.
Due to this two tables were effected. But we were able to access some of the records becuase they were part of other datafile and would fail when they try to access data in the offline datafile.

One of the table had a CLOB column, so customers are able to see all other column data except the CLOB column data.

So, when a records is saved it should save either completely or rollback completely. How can this CLOB column be missing.
Even if this clob column was part of the offline datafile, it should not show the enitre record, how can other columns data be visible and not this CLOB column value.

Can any one please explain. Our customers are bombarding us.

We are using oracle 8.1.7.4 and solaris 5.8.

regards
anandkl