drop user HZJJK cascade;
--删除表空间
drop tablespace "ZJJK_001";
drop tablespace "ZJJK_002";
drop tablespace "ZJJK_003";
drop tablespace "ZJJK_004";
drop tablespace "ZJJK_005";
drop tablespace "ZJJK_006";
drop tablespace "ZJJK_007";
drop tablespace "ZJJK_008";
drop tablespace "ZJJK_009";
drop tablespace "ZJJK_010";
drop tablespace "ZJJK_011";
drop tablespace "ZJJK_012";
drop tablespace "ZJJK_013";
drop tablespace "ZJJK_014";
drop tablespace "ZJJK_015";
drop tablespace "ZJJK_016";
--删除表空间组
SP_TS_GROUP_DROP('ZJJK_TSG');
--查看已有表空间组的名称
SELECT * FROM SYSTSGROUPS;--查看表空间组的成员
SP_GET_ALL_TS_BY_TSGROUP('ZJJK_TSG');


SELECT OWNER, TABLE_NAME 
FROM DBA_TABLES 
WHERE TABLESPACE_NAME in ('ZJJK_002','ZJJK_016','ZJJK_014','ZJJK_013','ZJJK_012','ZJJK_011');