Disabling Constraints and Triggers.

[Speed]

I have used PL/SQL Developer to export data from one environment (Production) and import it into another environment (Development). When I did this, I used the Disable Triggers and Disable Foreign Key Contraints options.

Is it possible to do a similar thing with Direct Oracle Access? How can I temporarily disable the foreign key constraints and triggers using DOA? I want to provide an option that allows the users to basically copy all of the Production data to the Development environment.

Thanks.

Regards,

Steve

 

[Marco Kalter]

You will need to query the Oracle dictionary (all_constraints, all_triggers) to determine which foreign key constraints and triggers reference the table(s), and execute the necessary DDL statements to disable/enable them.