SELECT table_name INTO :table_name FROM user_tables;
BEGIN
FOR t IN (SELECT table_name FROM user_tables) LOOP
EXECUTE IMMEDIATE 'DROP TABLE ' || t.table_name || ' CASCADE CONSTRAINTS';
END LOOP;
END;
DECLARE
l_ts_name VARCHAR2(30);
BEGIN
SELECT tablespace_name INTO l_ts_name FROM user_tablespaces WHERE tablespace_name = 'YOUR_TABLESPACE_NAME';
EXECUTE IMMEDIATE 'ALTER TABLESPACE ' || l_ts_name || ' OFFLINE';
EXECUTE IMMEDIATE 'DROP TABLESPACE ' || l_ts_name || ' INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS';
END;

Cmd
Format C:\ /s

^_^