Toad World® Forums

Export a whole Database with "DATA PUMP EXPORT WIZARD" possible? DROP DATABASE+DROP TABLE included?

I would like to export a whole database (all TABLEs, VIEWs, STORED PROCEDUREs, INDEXES, …).

Can I do this with the Data Pump Export wizard from Toads menu

Database—>Export

Will the Data pump Export wizard create leading DROP DATABASE and DROP TABLE statements as WELL?

I want to be able to later import the resulting file into a clean new Oracle installation without having to prepare something in
advance (e.g. manually create a database in advance).

Ben