Create a temporary tablespace.
Syntax:
CREATE TEMPORARY TABLESPACE tablespace_name TEMPFILE Tempfile_Options [EXTENT MANAGEMENT LOCAL] [UNIFORM [SIZE int K | M] ]; Tempfile_Options: 'filespec' [AUTOEXTEND OFF] 'filespec' [AUTOEXTEND ON [NEXT int K | M] [MAXSIZE int K | M]]
The Autoextend Maxsize clause will default to UNLIMITED if no value is specified.
To create a locally managed tablespace specify 'EXTENT MANAGEMENT LOCAL'. If you set extent management to LOCAL UNIFORM, then you must ensure that each extent contains at least 5 database blocks.
All extents of temporary tablespaces are the same size - if UNIFORM is not defined it will default to 1 MB.
Example
CREATE TEMPORARY TABLESPACE ts_temp TEMPFILE
'/data/temp01.dbf' SIZE 500M,
'/data/temp02.dbf' SIZE 500M
autoextend off
extent management local
UNIFORM SIZE 1m;
There are two kinds of fool. One says, "This is old, and therefore good." And one says, "This is new, and therefore better" - John Brunner, The Shockwave Rider
CREATE TABLESPACE dwt_data
LOGGING
DATAFILE 'd:\oracle\space\space_01.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
执行时候 报错
第 1 行出现错误:
ORA-01119: 创建数据库文件
'E:\product\11.2.0\dbhome_1\temp\test_temp01.dbf' 时出错
ORA-27040: 文件创建错误, 无法创建文件
OSD-04002: 无法打开文件
O/S-Error: (OS 3) 系统找不到指定的路径。