I am running a query selecting well over 150 columns of data out of our database. Hence it takes forever to run. I am getting the 'unable to extend rollback segment'...... and therefore it never completes. I have set the rollback space to unlimited and even added datafiles and still nothing. I know the suggestion has been to do commits (ie when inserting or updating) but what about on a single select statement?