Re: any unix/linux script to generate schema DDL?
- From: Daniel Fink <daniel.fink@xxxxxxxxxxxxxx>
- To: guangmei@xxxxxxxxx
- Date: Wed, 06 Aug 2008 10:08:18 -0600
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
Other related posts:
