@echo off set /p oracle_tb="input oracle tablespace: " set sql_path="." set /p flag="execute Y|N: " if %flag%==Y (sqlplus / as sysdba @%sql_path%\drop_tablespace.sql %oracle_tb%)