How to export triggers in an Oracle export command

Are your Oracle triggers not importing after an Oracle export? Learn why in this tip from expert Brian Peasland.

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.

Dig Deeper on Oracle database backup and recovery

SearchDataManagement
SearchBusinessAnalytics
SearchSAP
SearchSQLServer
TheServerSide.com
SearchDataCenter
SearchContentManagement
SearchHRSoftware
Close