oracle创建表空间

--创建临时表空间
create temporary tablespace jykl_temp
tempfile 'D:\oracle\jykl\jykl_temp.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
--创建数据表空间
create tablespace jykl_data
logging
datafile 'D:\oracle\jykl\jykl_data.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
--创建用户并指定表空间
create user jykl identified by jykl
default tablespace jykl_data
temporary tablespace jykl_temp;
--给用户授予权限
grant connect,resource to jykl;