Unanswered: replacing data in the table.(emptying)
I am using the following statement for replacing the data in the table instead of deleting the records. If I do the delete the records which are in thousands, the transaction log will get filled up unnecessarily which I don't want to do. I use the following command to replace the data of the table.
load from C:\test.sql of ixf replace into alert_history;
where test.sql is a empty file and alert_history is the name of the table.
But the table records are not getting emptied.
May I know is there anything I need to do apart from this.
The alert_history table here has around 200,000 records and I am OK even if I loose the data of the table after replacement.