Toad World® Forums

Generate DDL schema from command line

Hi,

I am currently using TOAD for Oracle 12.1 version to generate DDL scripts for the selected objects in a schema. My goal is to back up the current schema ddl every after release. I am trying to automate this process and am wondering if I can use the command line to invoke Toad to generate the required DDL scripts in the similar folder structure for each object type.
Any help will be much appriciated.

Thanks,
Sam

Go into the automation designer and create a Generate Schema Script action. The “Create individual Object DDL files” will make a folder for each object type, a file for each object’s script, and a master script to call all of the individual scripts.

Thanks John. Can you please provide a lit bit more detail on the steps. Or if you could point me to other source to refer that it would be great. I think I get what you are saying but I am new to using automation designer.

Sam

Hi Sam,

See attachment.

-John
SchemaScriptCommandLine.docx (716 KB)

Thank you John. Appriciate your help and prompt response. Cheers!!

I am able to run this through my local pc. Is it possible to run this script in the unix server? Not sure if there’s any Toad client version for the unix box.

Sorry, we don’t have a Unix version. Just Windows and Mac but I don’t know if all this stuff works in the Mac version.

Thanks John.