Disabling constraints before obfuscation

[Ashish Jaiswal]

Hi,

We are obfuscating around 5TB of data segregated in total 8 databases in Oracle which takes around 20-25 hours.
We are just disabling triggers at the moment.
Will disabling constraints before triggering obfuscation will reduce the overall obfuscation time and will not create any data integrity issue?

Please share your feedback on it. Much appreciated.

Thanks,
Ashish

[Abderrahmane Zahrir]

Hi Ashish,

disabling triggers would improve performance. However you should check with your DBA about which triggers to keep enabled and which triggers to disable to ensure data integrity.

REgards, Dahman

[Deactivated User]

We disabled constraints on columns we were masking and also set indexes to invalid, then rebuilt them afterwards. As Dahman points out, be careful that you don't mask a column to a value which will later fail a validation constraint you re-enable.

[Ashish Jaiswal]

Thank you Gary