Oracle创建表空间

创建表空间并定义路径：

create tablespace LIANGFAXIANJIE
datafile 'D:/app/PC/oradata/orcl/LIANGFAXIANJIE.dbf'
size 500m
autoextend on
next 50m maxsize 20480m
extent management local;

创建临时表空间并定义路径：

create temporary tablespace LIANGFAXIANJIE_TEMP
tempfile 'D:/app/PC/oradata/orcl/LIANGFAXIANJIE_TEMP.dbf'
size 32m
autoextend on next 32m maxsize 1024m
extent management local;