WHEN I TRIED TO RESIZE THE TABLESPACE , I GOT THE FOLLOWING ERROR... SQL> ALTER DATABASE DATAFILE '/hll05/oradata/hllrsnet/bev/index/bvbigcbx02.dbf' RESIZE 3400M; ALTER DATABASE DATAFILE '/hll05/oradata/hllrsnet/bev/index/bvbigcbx02.dbf' RESIZE 3400M * ERROR at line 1: ORA-01135: file 87 accessed for DML/query is offline ORA-01110: data file 87: '/hll05/oradata/hllrsnet/bev/index/bvbigcbx02.dbf' =========================================== SQL> ALTER DATABASE DATAFILE '/hll05/oradata/hllrsnet/bev/index/bvbigcbx02.dbf' ONLINE; ALTER DATABASE DATAFILE '/hll05/oradata/hllrsnet/bev/index/bvbigcbx02.dbf' ONLINE * ERROR at line 1: ORA-01122: database file 87 failed verification check ORA-01110: data file 87: '/hll05/oradata/hllrsnet/bev/index/bvbigcbx02.dbf' ORA-01200: actual file size of 396800 is smaller than correct size of 403200 bloc