Oracle数据库创建表空间

drop tablespace qb including contents and datafiles;DROP TABLESPACE TJLGL INCLUDING CONTENTS AND DATAFILES;drop user qb cascadecreate tablespace qbloggingdatafile 'E:\app\landa6\oradata\qb.DBF' --(表空间路径)size 32m autoextend on next 32m extent management local;create user qb identified by qb default tablespace qbgrant dba to qb;--(分配权限给用户)SELECT 'DELETE FROM '|| table_name || ';' FROM USER_TABLES ORDER BY TABLE_NAME;