oracle 用户表空间 创建指定删除

/*级联删除用户及数据空间*/
DROP USER DB1015 CASCADE;

/*创建临时表空间 */
create temporary tablespace DB_DEFAULT_TEMP
tempfile 'D:\oracle\product\10.2.0\oradata\DB\DB_DEFAULT_TEMP.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;

/*创建数据表空间 */
create tablespace DB_DEFAULT_DATA
logging
datafile 'D:\oracle\product\10.2.0\oradata\DB\DB_DEFAULT_DATA.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;

/*创建用户并指定表空间 */
-- Create the user
create user DB_1015 identified by DB_1015
default tablespace DB_DEFAULT_DATA
temporary tablespace DB_DEFAULT_TEMP
profile DEFAULT;

/*给用户授予权限 */
-- Grant/Revoke role privileges
grant dba to DB_1015;
-- Grant/Revoke system privileges
grant unlimited tablespace to DB_1015;

--删除表空间，同时删除数据文件：
drop tablespace DB_DEFAULT_TEMP including contents and datafiles;