Oracle 8.1.7 - Trigger body definition
We are using Oracle 8.1.7 database on AIX, we are planning to do a data purge on some huge tables which will delete customer data from 1999 to 2007, and we are expecting to gain over 40GB of data at the end of the purge activity.
We tried to delete the data for one year in a test setup with similar configuration and it took over 66 hours and we want to tune this delete activity.
We also found that the tables have triggers which gets invoked for every delete and we are not in a position to disable the triggers since it may have dependency with other tables and it may delete the data from the dependent tables also.
We tried to delete the data for one year in a test setup with similar configuration and it took over 66 hours and we want to tune this delete activity.
We also found that the tables have triggers which gets invoked for every delete and we are not in a position to disable the triggers since it may have dependency with other tables and it may delete the data from the dependent tables also.
0