DBMS_METADATA to extract triggers

List,

Has anyone used this utility to extract triggers from
a schema, then run the generated DDL script in another
database? I have extracted 76 triggers from the source
database, about 4,700 lines of code. When I run the
generated DDL into the destination database, only 2
triggers are cataloged. The generated file contains
all the required semicolons (except for the alter
trigger enable lines, which I had to insert manually).
I have these SQL*Plus commands at the start of the
dmbs_metadata script: 
set long 99999
set lines 120 space 0 heading off feedb off

Did I miss something?

Thanks!!

Don


        
                
__________________________________ 
Yahoo! for Good - Make a difference this year. 
http://brand.yahoo.com/cybergivingweek2005/
--
http://www.freelists.org/webpage/oracle-l

Other related posts: