Tamil / Ken : How do I delete just the locked rows ? And, if I may know, why do you think the rownum based solution will not work ? Any technical reason for that ?
__________________
svk
You can use "where current of" to delete locked rows.

The reason for locking is no one can change/update/delete the rows that you want to insert into archived table.
You can use rownum, however you must use "FOR UPDATE" along with "SELECT" statement.

For performance reason NOLOGGING, APPEND, multiple threades etc can be used, but they will not solve basic logic.

Tamil