What it does is, it stores data to the specified file location. I have been told that this spooling feature is in MYSQL also. Thanks.

oh !!! I meant to say, Spooling feature in SQLPlus. Thanks

Thanks for your help Phil. Problem has been solved. What I did was instead of importing whole database, I tried one table at a time. Thanks