My question is when the database is in No Archive log mode i'm not able to take the datafile offline.
When i tried in my computer i have noticed fallowing.
case1:
SYS>alter database datafile 5 offline;
ERROR at line1;
ORA-01145:offline immediate disallowed unless media recovery enabled.
case 2:
SYS>alter database datafile 5 offline immediate;
ERROR at line 1;
ORA-00933:SQL command not properly ended
case3:
I have tried the command alter database datafile 6 offline drop; (in NOARCHIVELOG mode) and it is showing the same effect as alter database datafile 6 offline; ( in ARCHIVELOG mode).
*In the NOARCHIVELOG mode are we really dropping the datafile to take the datafile offline? Will you please tell me the effect of keyword drop.