创建临时表空间
create temporary tablespace yycg0730
tempfile 'F:\OracleInstal\oradata\yycg\yycg0730.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
创建数据表空间
create tablespace yycg0730
logging
datafile 'F:\OracleInstal\oradata\yycg\yycg0730.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
创建用户并指定表空间
create user yycg0730 identified by yycg0730
default tablespace yycg0730
temporary tablespace temp;
给用户授予权限
grant connect,resource,dba to yycg0730