I am trying to take undo datafile in offline mode using following command
alter database datafile '<datafile path>' offline;
this datafile is in recovery mode. Oracle shows message as database successfully altered.
But after executing this command when I select entries in v$tablespace. The file that I just made offline remains in this table.
Can somebody please tell how to take undo datafile offline.
OS: RHEL
Oracle version: 11g
Datafile status: Recovery
Best Answer
Shouldn't you be looking in v$datafile to see if a datafile is offline rather than v$tablespace?
Offline Datafile:
Online Datafile: