oracle删除数据库表空间信息报错 ORA-01116、ORA-01110、ORA-27041

oracle19c
业务场景：删除TS_IND_ICRM表空间
查看，表空间存在。

SQL> select * from dba_data_files WHERE UPPER(tablespace_name) = 'TS_IND_ICRM';
FILE_NAME                                                                           FILE_ID TABLESPACE_NAME                     BYTES     BLOCKS STATUS    RELATIVE_FNO AUTOEXTENSIBLE   MAXBYTES  MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS ONLINE_STATUS LOST_WRITE_PROTECT
-------------------------------------------------------------------------------- ---------- ------------------------------ ---------- ---------- --------- ------------ -------------- ---------- ---------- ------------ ---------- ----------- ------------- ------------------
/home/oracle/oradata/crmdb/datafile/ts_ind_icrm01.dbf                                    17 TS_IND_ICRM                    5368709120     655360 AVAILABLE           17 YES            3435972198    4194302            1 5367660544      655232 ONLINE        OFF

SQL> 

执行删除表空间

SQL> DROP TABLESPACE TS_IND_ICRM;
DROP TABLESPACE TS_IND_ICRM
ORA-01116: error in opening database file 17
ORA-01110: data file 17: '/home/oracle/oradata/crmdb/datafile/ts_ind_icrm01.dbf'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

SQL> 

正确执行

SQL> alter database datafile '/home/oracle/oradata/crmdb/datafile/ts_ind_icrm01.dbf' offline drop;
Database altered

SQL> 
Tablespace dropped

SQL> 

at last:
想建一个数据库技术的交流群，用于磨炼提升技术能力.群号： 130730832 ,欢迎大佬前来教学。