Oracle 用SQL创建表空间

一、创建临时表空间

create temporary tablespace HEAT_CHARGE_SHENGDILAN_TEMP

tempfile 'F:\oracle11g\oradata\orcl\HEAT_CHARGE_SHENGDILAN_TEMP.dbf'

size 50m

autoextend on

next 50m maxsize 20480m

extent management local;

二、创建数据表空间

create tablespace HEAT_CHARGE_SHENGDILAN

logging

datafile 'F:\oracle11g\oradata\orcl\HEAT_CHARGE_SHENGDILAN.dbf'

size 50m

autoextend on

next 50m maxsize 20480m

extent management local;