"Translated from MoS article" in case the OS datafile no longer exists, remove the tablespace

From:
I want to remove a tablespace and the datafile are already removed from the O.s (document ID 786567.1)

Suitable for:
Oracle database-enterprise edition-version 10.1.0.4 and later
Information in this document applies to any platform.

Goal:
When DataFile is removed from the OS level and then tries to drop the tablespace, the results report the following error:

sql> drop tablespace ts_edw1_large01;drop tablespace ts_edw1_large01*error at line 1:ora-01115:io ERROR reading block From file (Block # 1) ora-01110:data file: '/u43/oradata/edw1p/ts_edw1_large01_01.dbf ' ora-27091:unable to queue I/O Ora-27072:file I/o erroradditional information:3additional information:1

Solution:

1. sql> STARTUP MOUNT; 2. Offline drop the datafile. sql> ALTER DATABASE datafile '/u43/oradata/edw1p/ts_edw1_large01_01.dbf ' OFFLINE drop;3. Sql> ALTER DATABASE open;4. Drop the user tablespace. Sql> DROP tablespace <tablespace_name> including CONTENTS;

"Translated from MoS article" in case the OS datafile no longer exists, remove the tablespace