Thank Rajeev
When I tried datafile offline the following message occur>
ORA-01145: offline immediate disallowed unless media recovery enabled. Any suggestion how to do this. I am reading up on this. I am a Newbie in Oracle and a have been in MSSQL.
thanks
dev