Taking UNDO datafile offline/online
Can someone please tell me what went wrong here .....
=================================================
SQL> alter tablespace psapundo
2 add datafile 'D:\UNDOFILE01' size 1m;
Tablespace altered.
SQL> alter database datafile 'D:\UNDOFILE01.DBF' offline;
Database altered.
SQL> alter database datafile 'D:\UNDOFILE01.DBF' online;
alter database datafile 'D:\UNDOFILE01.DBF' online
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: 'D:\UNDOFILE01.DBF'