How to Export Triggers With Oracle
Triggers are procedures that run on your database tables after you insert, update or delete records. Oracle includes an interface for running procedures on the database. The "expdp" command exports the triggers from your table, so you can create a backup of the triggers before you redesign or change the table's structure. It also stores the procedure's code, so you do not need to recode the triggers after a table change.
Other People Are Reading
Instructions
-
-
1
Open the Oracle Enterprise Manager from your Windows program menu on your database server or a computer that has connection access to the database.
-
2
Log in to the server and open the PL/SQL editor. Type the following code in the editor and replace "tablename" with the table that contains your triggers and "database" with the name of your database:
expdp database tables=(tablename) -
-
3
Click "Execute" to run the export statement. The Oracle database returns a success message after the statement completes.
-
1
