RE: any unix/linux script to generate schema DDL?
- From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- To: guangmei@xxxxxxxxx, "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 6 Aug 2008 12:21:28 -0400
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.
Regards,
Paul Baumgartel
CREDIT SUISSE
Information Technology
Prime Services Databases Americas
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel@xxxxxxxxxxxxxxxxx
www.credit-suisse.com
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Daniel Fink
Sent: Wednesday, August 06, 2008 12:08 PM
To: guangmei@xxxxxxxxx
Cc: oracle-l-freelists
Subject: Re: any unix/linux script to generate schema DDL?
Guang,
You can find some of my dbms_metadata sql scripts (use at your own risk
because dbms_metadata is buggy as hell!) at
http://www.optimaldba.com/scripts.html. All you need to do is wrap the
script in your favorite unix language script.
Regards,
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
http://www.couragetours.com/2008/danielwfink to donate
OptimalDBA.com - Oracle Performance, Diagnosis, Data Recovery and
Training
OptimalDBA http://www.optimaldba.com
Oracle Blog http://optimaldba.blogspot.com
Lost Data? http://www.ora600.be/
Guang Mei wrote:
> Hi,
>
> Oracle 10.2.0.1.0
>
> 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
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
==============================================================================
Please access the attached hyperlink for an important electronic communications
disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================
--
//www.freelists.org/webpage/oracle-l
Other related posts:
