How to export triggers in an Oracle export command
By Brian Peasland, Database Administrator, SGT, Inc.
SearchOracle.com
When I export and then import a user using the Oracle 8 client, the triggers of the tables are not imported. Can you help?
If you want to ensure the triggers are exported, add the TRIGGERS=Y parameter to your export command. Otherwise, without seeing the exact import and export commands, I am not sure what problem is arising.
Oracle White Papers: Fusion Middleware