1、查看本数据库的表空间存放的位置

select * from dba_data_files

2、创建临时表空间

create temporary tablespace user_temp

tempfile 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\user_temp.dbf'

size 50m

autoextend on

next 50m maxsize 5000m

extent management local;

3、创建表空间

create tablespace user_data
logging
datafile 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\user_data.dbf'
size 50m
autoextend on
next 50m maxsize 5000m
extent management local;

4、指定表空间

alter user zhen
default tablespace user_data
temporary tablespace user_temp;