Thanks friend..

But if i require to drop the datafile means what has to be done..

I heard that we have option to drop datafile in 9i and above. Not sure b4 9i.

Please correct me if i'm wrong...