1.创建表空间
create tablespace bos
datafile 'c:\bos.dbf'
size 100m
autoextend on
next 10m;
2.创建用户
create user bos
identified by bos
default tablespace bos;
3.给用户授权
grant connect to bos;
grant resource to bos;
4.删除用户
drop user bos cascade;
5.删除表空间
drop tablespace bos;
Oracle环境准备
最新推荐文章于 2024-07-12 07:13:33 发布