Hi all

At the time of creating the database I did not create Undo Tablespace. Then after installation I tried below options, Can you please tell me which process is correct.

1. I update my init parameter file with
UNDO_MANAGEMENT=Auto
UNDO_TABLEPSACE= undotbs01
UNDO_RETENTION=900

and created a Undo tablespace too.

Then I startup my database. Is it fine? Will it work?



2. Else tried thru SPFILE...

alter system set UNDO_MANAGEMENT=auto
comment='Making Undo tablespace'
Scope=SPFILE;

I am getting this error ' ORA-32001: write to SPFILE requested but no SPFILE specified at startup'


and for other two scopes, it is not working.


Please help me