//创建临时表空间
create temporary tablespace tpts_temp
tempfile 'D:\oracle\product\10.2.0\oradata\orcl\tpts_temp01.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
//创建数据表空间
create tablespace ts_name
logging
datafile 'D:\oracle\product\10.2.0\oradata\orcl\ts_name01.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
//创建用户并指定表空间
create user username identified by password
default tablespace ts_name
temporary tablespace tpts_temp;
//给用户授予权限
grant connect,resource to username;
oracle创建表空间、用户
最新推荐文章于 2024-10-06 21:49:48 发布