Thanks friends,
My mistake in assuming that it was hanging. Indeed it was not.
I got the following error.


ORA-01562: failed to extend rollback segment number 1
ORA-01628: max # extents (200) reached for rollback segment R01
ORA-01562: failed to extend rollback segment number 1
ORA-01628: max # extents (200) reached for rollback segment R01
ORA-06512: at line 13


I guess now I need to create a large rbs and assign to that. Is that OK?
Thanks
manjunath