How to export DDL without duplicating object definition? (4325099)

When performing an "Export DDL" via Toad, trigger definitions are duplicated.

The customer checked the tables and triggers on the options tab when he clicked the ADD button to select the objects to be exported.

To avoid duplication of DDL, use "One file per schema" output in the "Objects and output" tab then just check table and not triggers. This will make the file more organized compared to saving file in "Single file" especially if you have more than 1 schema. This will save the exported DDL file in 1 file per schema. If trigger is to be added in the exported file, go to "script options" tab then check trigger and other related object of the table.

Attached is a step by step instruction on how to export DDL .