oracle创建表空间

-- 创建临时表空间
CREATE TEMPORARY TABLESPACE lucene_temp
TEMPFILE 'D:\oracle\product\10.2.0\oradata\orcl\lucene_temp.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M

EXTENT MANAGEMENT LOCAL;

--创建用户表空间
CREATE TABLESPACE lucene_data
LOGGING
DATAFILE 'D:\oracle\product\10.2.0\oradata\orcl\lucene_data.dbf' 
SIZE 32M 
AUTOEXTEND ON 
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;