hi pando,

v$datafile now shows me status shows me recover , dba studioshows me offline(recover) status. recover database gives me an error saying nothing to recover. if i give drop tablespace XXXX including contents, it will delete the entire tablespace, right ? is it okay if i let the datafile be as it is and continue with my normal work ? or will it give me problems in the future. this is not a permanent database. and i can change it sometime in the future. waiting for ur coooments)