Toad World® Forums

Dump File

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.