Create tablespace liuqy_s
Logging
datafile 'D:\Oracle\database\liuqy_s.dbf'
size 50M
Autoextend on
next 50 maxsize 2048m
extent management local;
------创建数据表空间
Create temporary tablespace test_liuqy_s
tempfile 'D:\Oracle\database\test_liuqy_s.dbf'
size 50M
autoextend on
next 50M maxsize 2048m
extent management local;
------创建临时表空间
create user liuqy
identified by liuqy
default tablespace liuqy_s
temporary tablespace test_liuqy_s;
-----创建用户并指定表空间
grant create session to liuqy;
-----给用户授予权限
Logging
datafile 'D:\Oracle\database\liuqy_s.dbf'
size 50M
Autoextend on
next 50 maxsize 2048m
extent management local;
------创建数据表空间
Create temporary tablespace test_liuqy_s
tempfile 'D:\Oracle\database\test_liuqy_s.dbf'
size 50M
autoextend on
next 50M maxsize 2048m
extent management local;
------创建临时表空间
create user liuqy
identified by liuqy
default tablespace liuqy_s
temporary tablespace test_liuqy_s;
-----创建用户并指定表空间
grant create session to liuqy;
-----给用户授予权限