Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!pd7cy2so!pd7cy1no!shaw.ca!sjc70.webusenet.com!news.webusenet.com!cyclone.bc.net!logbridge.uoregon.edu!arclight.uoregon.edu!wn13feed!worldnet.att.net!204.127.198.203!attbi_feed3!attbi.com!attbi_s04.POSTED!not-for-mail Newsgroups: comp.databases.oracle.server From: "Charles J. Fisher" Subject: Re: plsql trigger ddl extraction In-Reply-To: Message-ID: References: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Lines: 15 NNTP-Posting-Host: 12.217.90.112 X-Complaints-To: abuse@mchsi.com X-Trace: attbi_s04 1068602562 12.217.90.112 (Wed, 12 Nov 2003 02:02:42 GMT) NNTP-Posting-Date: Wed, 12 Nov 2003 02:02:42 GMT Organization: MediaCom High Speed Internet Date: Wed, 12 Nov 2003 02:02:42 GMT Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:247490 On Wed, 12 Nov 2003, KevJohnP wrote: > For info, from 9i onwards you can get DDL using the DBMS_METADATA > package, example as follows; > SELECT dbms_metadata.get_ddl('TRIGGER','MYTRIGGER','MYSCHEMA') > FROM dual That's no good; this needs to work in Oracle versions 7 and 8 (7's lack of ALTER TABLE MOVE is a major motivator for some of this). -------------------------------------------------------------------------- / Charles J. Fisher | "Have I done an unselfish thing? Well then, I / / cfisher@rhadmin.org | have my reward. Keep this thought ever / / http://rhadmin.org | present, and persevere." -Marcus Aurelius / --------------------------------------------------------------------------