RE: any unix/linux script to generate schema DDL?

From: Baumgartel, Paul <>
Date: Wed, 6 Aug 2008 12:21:28 -0400
Message-ID: <>

I have developed an Oracle10g package using dbms_metadata that generates all of the DDL for a schema, stores it in a table, and (optionally) writes it to a flat file. It works pretty reliably. Email me privately if you would like a copy.


Paul Baumgartel
Information Technology
Prime Services Databases Americas
One Madison Avenue
New York, NY 10010
Phone 212.538.1143

-----Original Message-----
[] On Behalf Of Daniel Fink Sent: Wednesday, August 06, 2008 12:08 PM To:
Cc: oracle-l-freelists
Subject: Re: any unix/linux script to generate schema DDL?


You can find some of my dbms_metadata sql scripts (use at your own risk because dbms_metadata is buggy as hell!) at All you need to do is wrap the script in your favorite unix language script.

Daniel Fink

Daniel Fink

Help me support The Children's Hospital of Denver! 
I'm riding in the 2008 Courage Classic - 157 miles in 3 days
Help me reach my goal of $2,500.00 in donations.  
Visit my Personal Rider Page to donate - Oracle Performance, Diagnosis, Data Recovery and

Oracle Blog

Lost Data?

Guang Mei wrote:

> Hi,
> Oracle
> Does anyone know any sites or URL that has unix/linux script(s) to
generate a schema DDL (including tables, index, views, package code, store procs, etc), say using soemthing like DBMS_METADATA.GET_DDL? I can use Oracle SQLDeveloper to do it manually, but I would like to have the script called by a cron job. BTW, I do not want to use dump file to import the db structure, just some unix/linux script to "extract" schema DDL. I googled around but could not find one.
> TIA.
> Guang
> --
-- ============================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: ============================================================================== --
Received on Wed Aug 06 2008 - 11:21:28 CDT

Original text of this message