ORA-01092 & ORA-30040
ORA-01092 & ORA-30040 · Mount the database. · Create a pfile from spfile to a desired location. For example CREATE PFILE = ‘f:\temp\test\initorcl.ora’ from spfile; · Edit the pfile and give an online tablespace *.undo_tablespace='UNDOTBS3' already existing. · Start the database with this new Pfile, for example STARTUP PFILE=’F:\TEMP\TEST\initorcl.ora’ · Create spfile from the new pfile settings loaded using the command “CREATE SPFILE FROM PFILE;” · Bounce the database.