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.

Comments

Popular posts from this blog

Current Variables in T24

All accounting entries of an T24 account

SQL queries in JBase