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