Oracle Database Discussions

Hello all,

Can we set Nologging option for undo tablespace. I have tried to set it using "alter tablespace undo nologging" but get an error.

Is it mean that undo tablespace always remain in Logging mode and one cannot change it to nologging mode?

if Yes then is it because we need undo changes present in Undo segments to log in the redo logs file like other DML/DDL statements so that at the time of instance recovery SMON use those and reconstruct undo segment so that rollback for uncomitted trasaction take place.

Thankyou