How to Export the huge data retrieved by query in Toad?
426951Sep 12 2005 — edited Sep 12 2005Hello,
I know its not the exact forum to post this thread, but still I hope that I can get some help from this forum.
I have executed a query at TOAD and its showing me huge data, I want to export the data in some file by using the "Save As" option of TOAD. The query is returning more than 65000 records whcih eliminates the use of XLS format.
I have tried all other file format options available with Save As.
TOAD get stuck at 16500 records and just hangs. I have tried the "clone cursor" setting as well although I know very little of this setting.
Any idea how to make it possible to save the data?
If you have any ideas, please let me know.
Thanks in advance.
Himanshu