1. 创建表空间:
BEGIN
DECLARE
cnt integer := 0;
BEGIN
SELECT 1 INTO cnt FROM dual WHERE exists(SELECT * FROM user_tablespaces WHERE tablespace_name = UPPER(TRIM(‘TEST‘)));
IF cnt != 0 THEN
DECLARE
s VARCHAR2(500);
BEGIN
s := ‘DROP TABLESPACE TEST INCLUDING CONTENTS CASCADE CONSTRAINTS‘;
DBMS_OUTPUT.PUT_LINE(s);
EXECUTE IMMEDIATE s;
END;
END IF;
exception
WHEN no_data_found THEN
DBMS_OUTPUT.PUT_LINE(cnt);
END;
END;
/
BEGIN
DECLARE
cnt integer := 0;
BEGIN
SELECT 1 INTO cnt FROM dual WHERE exists(SELECT * FROM user_tablespaces WHERE tablespace_name = UPPER(TRIM(‘TEST_TEMP‘)));
IF cnt != 0 THEN
DECLARE
s VARCHAR2(500);
BEGIN
s := ‘DROP TABLESPACE TEST_TEMP I