So raghu, you mean to say that taking the tablespace offline, dropping & recreating the datafile should work fine ? What are the other issues I need to take care of ?

Shiva.