Generating Create & Insert Script using TOAD at once for an oracle db

Question

we have a DB with lots of tables related to our application (not all ), views, triggers, functions, procedures etc.

Is there any way to generate script to create those objects in another DB + insert statements.

We don't want to take DB backup as it has lot other things.

please suggest.

Coding Duchess · Accepted Answer · 2012-12-05 20:50:12Z

1

you could use DBMS_METADATA to extract the DDL

oryou could use SQL Developer Tools->Database Export

in Toad you can use Database->Export->Export DDL

answered Dec 5, 2012 at 20:36

Coding Duchess

7,01927 gold badges146 silver badges244 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1