plsql12配置数据库连接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;--删除⽤户

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。