Re: truncate table gives rollback segment error ?

Jan-Olav Eide wrote:
>
> I thought TRUNCATE TABLE did not use rollback segments.
> Why do I still get an ORA-01562 (failed to extend rollback segment)
> when trying to truncate a large table ?
>
> --
> jo

If its got many, many extents then a lot of internal dictionary work is needed - which will need rollback...

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"