-
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'
-
Can u please post the results of
=================================================
SQL> alter tablespace psapundo
2 add datafile 'D:\UNDOFILE01' size 1m;
Tablespace altered.
select name,status,CREATION_TIME,CREATION_CHANGE# from v$datafile
where name='D:\UNDOFILE01'
SQL> alter database datafile 'D:\UNDOFILE01.DBF' offline;
Database altered.
select name,status,CREATION_TIME,CREATION_CHANGE# from v$datafile
where name='D:\UNDOFILE01'
-
Status Creation_time Creation_change#
------- --------- ----------------
Online 15-jun-07 4009156
-
What about after u make it offline?
-
Above result , i got it after making it offline
Status Creation_time Creation_change#
------- --------- ----------------
Online 15-jun-07 4009156
i wonder is there some exception for UNDO tablespace datafiles
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
|