1、创建表空间
create tablespace tablespace_name
logging
datafile 'F:\app\tablespace_name.dbf'
size 200m
autoextend on
next 50m maxsize 20480m
extent management local;
2、创建临时表空间
create temporary tablespace tmp_tablespace_name
tempfile 'F:\appkaoshi_temp.dbf'
size 100m
autoextend on
next 50m maxsize 20480m
extent management local;
3、创建用户,指定表空间
create user username identified by password
default tablespace <