Increase the size of the rbs. Yes, remove the savepoint (it's only a reference point in a transaction). Yes, if it fails to delete, the transaction will rollback. Oracle randomly selects a rbs when a transaction begins. If you want it to use a specific rbs, then issue: set transaction use rollback segment (name); before beginning the transaction.