If you need to get rid of some table rows, in my case a Sun IDM logging table, you can use the following steps. 1. Create a backup in case you have done some thing wrong u can always revert back. create table waveset.log_backup as select * from waveset.