Re: Segment management auto clause

Peter wrote:
>
> If I set the UNDO_MANAGEMENT=AUTO init parameter, Oracle is supposed
> to manage undo automatically. So if I create a tablespace, do I still
> need to include the "SEGMENT MANAGEMENT AUTO" clause?
>
> Thanks

segment management auto is totally *unrelated* to undo. It is a replacement for manual freelist/freespace management for objects in your database.

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

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