The way to deal with the mistaken deletion table space

This type of problem is usually caused by improper operation of the table space.
Workaround:

Sql*plus cannot connect, the following error is displayed:
Ora-01033:oracle initialization or shutdown in Progress,enterprise Manager console is also the same error.

Run cmd and enter the DOS environment.

C:\users\administrator>sqlplus

Sql*plus:release 10.2.0.1.0-production on Friday April 22 09:28:44 2016

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Please enter user name: Sys/sys as Sysdba

Connect to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production
With the partitioning, OLAP and Data Mining options

sql> ALTER DATABASE open;
ALTER DATABASE Open
*
An error occurred on line 1th:
ORA-01113: File 6 requires media recovery
ORA-01110: Data file 6: ' E:\TEST. ORA '

Sql> ALTER DATABASE datafile 6 offline drop;

The database has changed.

sql> ALTER DATABASE open;

The database has changed.

sql> Drop User Test cascade;//Note: This test will be with the ' E:\TEST ' above. The test in ORA ' corresponds.

The user has been deleted.

Sql> drop tablespace TEST including contents;

Table space has been deleted.

At this point, Sql*plus and Enterprise Manager console and so on can be normal landing.

The next step is to rebuild the tablespaces and users that were deleted during the problem resolution process.

Sql>create tablespace TEST datafile ' E:\test.dbf ' size 100m reuse autoextend on next 10m maxsize unlimited extent Manag Ement
Local
Sql>create user test default tablespace test indentified by Windows;

From for notes (Wiz)

The way to deal with the mistaken deletion table space