-
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'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|