ORA-02173: invalid option for DROP TABLESPACE
Cause: Either a token other than INCLUDING was found following the tablespace name or some text was found following INCLUDING CONTENTS.
Action: Place nothing or only INCLUDING CONTENTS after the tablespace name.
ORA-02173:DROP TABLESPACE操作的选项无效的意思,它是一个基础性的错误,正常状态下Oracle不会显示此错误。一般来说,当我们执行DROP TABLESPACE语句后,出现这个错误就说明DROP TABLESPACE语句的执行的参数不正确。
2、检查传入DROP TABLESPACE语句的参数是否正确。
3、确保传入DROP TABLESPACE语句的参数是正确的表空间名字。