CONFIRM THAT THE FILE IS DAMAGED BY ATTEMPTING TO QUERY THE TABLE CREATED IN THE TABLESPACE

2. Confirm that the file is damaged by attempting to query the table created in

the tablespace:

SQL> select * from t1;select * from *ERROR at line 1:ORA-01578: ORACLE data block corrupted (file # 7, block # 9)ORA-01110: data file 7: '/u01/app/oracle/oradata/orcl/ex181.dbf'