Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Dec 31 2005 - 01:32:10 CST
![]() |
![]() |