Triggers=Y/N is an option in the export. It's possible the export was
created w/o triggers. That's the most likely situation. You may want
to do an imp indexfile=filename.sql. That will dump out the ddl for the
dmp file to a text file so you can read it and look to see if your
triggers are there (invesitage the imp indexfile option, I haven't used
it in many years, so I may have the usage wrong...)

Are you importing the whole database or just one user/schema or a set of
tables? You just may want to be sure that the triggers are owned by the
user you think they're owned by, and that kind of thing.

Thanks,
Tim V.

-----Original Message-----
From: Anthony Ballo
[mailto:oracledba-ezmlmshield-x70142758.[Email address protected]
Sent: Friday, April 29, 2005 12:24 PM
To: LazyDBA Discussion
Subject: Exp/Imp - no triggers brought over


What's the best way to import Triggers from another db? I have only 8
that didn't come over.

I even tried exp/imp with ROWS=N but no triggers imported.

Ideas?


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page