I am using Toad for Oracle. I know that I can create dump files per table or database. But I want to create a dump file from the result set.
Ex: SELECT * FROM table_name WHERE condition; – i want to export only this result to a dump file.
Datapump has this option, but not EXP.
From the main menu in Toad: Database -> Export -> Data Pump Export.
When the window opens, choose the table that you want on the “Items” tab, and add you where clause on the “Queries” tab.