SuSE Linux 环境Oracle 创建临时表空间,错误ORA-01119、ORA-27040

刘洋 发布于 2012/08/29 18:00
阅读 5K+
收藏 0

-- 创建临时表空间
CREATE TEMPORARY TABLESPACE VoiceInsight_Temp
TEMPFILE '/home/oracle/oradata/test01/testTMP.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 500M
EXTENT MANAGEMENT LOCAL;

 

ORA-01119: error in creating database file

'/home/oracle/oradata/test01/testTMP.dbf'
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory

加载中
0
樊睿
樊睿
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> CREATE TEMPORARY TABLESPACE VoiceInsight_Temp
TEMPFILE '/home/oracle/oradata/test01/testTMP.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 500M
  6  EXTENT MANAGEMENT LOCAL;
CREATE TEMPORARY TABLESPACE VoiceInsight_Temp
*
ERROR at line 1:
ORA-01119: error in creating database file
'/home/oracle/oradata/test01/testTMP.dbf'
ORA-27040: file create error, unable to create file
Linux Error: 2: No such file or directory


SQL> !mkdir -p /home/oracle/oradata/test01

SQL> CREATE TEMPORARY TABLESPACE VoiceInsight_Temp
TEMPFILE '/home/oracle/oradata/test01/testTMP.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 500M
  6  EXTENT MANAGEMENT LOCAL;

Tablespace created.

SQL> drop tablespace VoiceInsight_Temp;

Tablespace dropped.

SQL> 

刘洋
刘洋
膜拜一下,解决了!谢谢!
0
樊睿
樊睿
先创建目录结构mkdir -p /home/oracle/oradata/test01/
刘洋
刘洋
这个方法之前试过,不行的!
返回顶部
顶部