Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> DBMS_METADATA to extract triggers

DBMS_METADATA to extract triggers

From: Don Morse <dmorse2_at_yahoo.com>
Date: 2005-12-31 01:32:10
Message-id: 20051231003210.48674.qmail@web50107.mail.yahoo.com


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
Received on Sat Dec 31 2005 - 01:32:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US