plsql的语句创建数据库及删除表空间及用户的语句

--创建临时表空间

create temporary tablespace lyrsj_temp 

tempfile 'D:\oradata\orcl\lyrsj_temp.dbf' 
size 320m 
autoextend on 
next 32m maxsize 2048m
extent management local;


--创建表空间

create tablespace lyrsj
logging
datafile 'D:\oradata\orcl\lyrsj_normal.dbf' 
size 320m 
autoextend on 
next 32m maxsize 2048m
extent management local;

--创建用户
create user lyrsj identified by lyrsj
default tablespace lyrsj
temporary tablespace lyrsj_temp;

--赋予权限
grant dba to lyrsj;


drop tablespace lyrsj including contents and datafiles CASCADE CONSTRAINTS;--删除表空间
 drop user lyrsj cascade;--删除用户