hi,
i hv upgraded my 8i test db to 10g. I wanted to switch to 10g's undo tablespace management and i hv created the undo tablespace...but i am at a lost how to switch the upgraded database to 10g's undo management as I cant seem to find a place to set the initialisation parameter UNDO_MANAGEMENT=AUTO as 10g is not using the text init.ora anymore...and i cant set it using 'Alter system set undo_management=auto' either it returns an error....wonder if anyone could help?

many thanks