Re: Help: unable to delete a tablespace

>ORA-00604: error occured at recursive SQL Level 1
>ORA-01562: failed to extend rollback segment (id=2)
>ORA-01547: failed to allocate extent of size 65 in tablespace 'RBS'

This just a guess, but I would say you ran out of room in the physical file which has your rollback table space in it. In the best of worlds your rollback tablespace would have it's own file/disk. However it may be in the same file as your data and the data took up all the room, so the rollback table space could not extend. The other way it can happen is if you have lots of transactions and no commits, so you fill up the rollback segments and sometimes the file that contains it.

I'm new at the DBA game, so I am Probably wrong about your problem, but take a look and see, I may just be right.

>Regards,
>Lee WN : leewn_at_oclmal.po.my

good luck.... :-)

####################################################################
Andrew John Bloomer         # 
Perth, Western Australia    #  This Space is left  intentionally
ajb_at_iinet.com.au            #               BLANK!
####################################################################