create tablespace命令报错的解决方法

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) 系统找不到指定的路径。

经过检查，路径没有创建。 create tablespace命令不会创建路径部分，如果找不到则会报错推出。  创建完整路径'E:\product\11.2.0\dbhome_1\temp\， 程序执行成功！