/*    说明:若已经存在相应的用户和表空间，则需要先删除相应的用户和表空间        然后再全部重新建立*/--删除用户drop user USERNAME cascade;--删除表空间drop tablespace DATA_TEMP including contents and datafiles;drop tablespace DATA      including contents and datafiles;--创建临时表空间create temporary tablespace DATA_TEMP tempfile ‘DATA_TEMP.DBF‘        size 500M autoextend on;--创建表空间create tablespace DATA logging datafile ‘DATA.DBF‘        size 500M autoextend on;--创建用户并指定表空间create user USERNAME        identified by USERNAME      default tablespace DATA      temporary tablespace DATA_TEMP     profile default;--给用户授予角色权限grant connect to USERNAME;grant resource to USERNAME;grant dba to USERNAME;--给用户授予系统权限grant unlimited tablespace to USERNAME;exit;