Originally posted by Calvin_Qiu
Wrong, It just take a datafile offline in unarchived mode instead of dropping it. Try to query the V$DATAFILE after your action.
ok so what, for all intents and purposes unless you online the file before you cycle through the online redo logs (in NO ARC mode)
that file is a distant memory, you can't get it back