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.