CREATE ROLLBACK SEGMENT BIG_RBS STORAGE(INITIAL 1M NEXT 1M OPTIMAL 1M MINEXTENTS 2);

ALTER ROLLBACK SEGMENT BIG_RBS ONLINE;
**drop indexes on the delete table if appropriate**
COMMIT;
SET TRANSACTION USE ROLLBACK SEGMENT BIG_RBS;
DELETE FROM ******** WHERE **********;
ALTER ROLLBACK SEGMENT BIG_RBS SHRINK;
ALTER ROLLBACK SEGMENT BIG_RBS OFFLINE;