ORA-01157: cannot identify/lock data file

Unfortunately I deleted dbf file from file system and I got stuck with the below error when trying to create table space.

SQL> create tablespace content_system datafile 'd:/UCM/tablespace/stellent_temp.dbf' size 500M;

create tablespace content_system datafile 'd:/UCM/tablespace/stellent_temp.dbf' size 500M

*

ERROR at line 1:

ORA-01109: database not open

Now the solution is,

SQL> alter database datafile 'd:/UCM/tablespace/stellent_temp.dbf' OFFLINE DROP;

Database altered.

SQL> alter database open;

Database altered.