Originally posted by ligang

the example of code for deletion is :

#!/bin/sh
svrmgrl << EOF
connect username/password;
alter table tb_name nologging;
Nologging will help only in certain cases like creating/rebuilding index. Delete info will be logged in the redo.

Secondly since you are committing inside a cursor, this should span several rollback segs and not just one, unless all your other RBS are full.

Slimdave...good input.