I don't know if I have enough hard drive space to do it all at once. It would be really close and I can't take that chance. I've done an export of the database so I am not entirely worried. But given the scanario that I couldn't do an export, is there another solution without incuring this error as a result of using cursors and periodic commits.