This content has been marked as final. Show 3 replies
And the fix is easy, as long as you don't mind shutting down the database and a startup mount;
And don't move sysaux.dbf onto the existing undotbs1.dbf, using a slightly different name would be a Very Good Idea ...
Of course, for those of you on Windows, it's going to cost four extra keystrokes ... mv ... move ;)
$ sqlplus /nolog shutdown immediate; ... database closed ... exit; cd <.dbf files directory> mv sysaux.dbf undotbs01.dbf mv undotbs1.dbf sysaux.dbf $ sqlplus /nolog startup mount ... mounted ... alter database rename file '<dir>/sysaux.dbf' to '<dir>/undotbs01.dbf'; alter database rename file '<dir>/undotbs1.dbf' to '<dir>/sysaux.dbf'; alter database open;