Q
Manage Learn to apply best practices and optimize your operations.

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

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close