oracle exp 写入文件时出错,oracle Exp 错误 不能 打开临时表文件

在用Oracle命令 Exp

导出数据时出现下列疑问

：

Exp

-00008: 遇到 ORACLE 错误 1116

ORA-01116: error in opening database file 201

ORA-01110: data file 201: '/opt/app/oracle/oradata/orcl/temp01.dbf'

ORA-27041: unable to open file

Linux Error: 2: No such file or directory

Additional information: 3

Exp

-00083: 调用 SYS.LT_Exp

ORT_PKG.system_info_exp

时出现前一疑问

Exp

-00008: 遇到 ORACLE 错误 1116

ORA-01116: error in opening database file 201

ORA-01110: data file 201: '/opt/app/oracle/oradata/orcl/temp01.dbf'

ORA-27041: unable to open file

Linux Error: 2: No such file or directory

如图：

处理

要领

：

1.最先

删除表空间文件 temp01.dbf

alter database tempfile '/opt/app/oracle/oradata/orcl/temp01.dbf' drop;

2.新建一个表空间文件 temp01.dbf

alter tablespace temp add tempfile '/opt/app/oracle/oradata/orcl/temp01.dbf' size 50m;

alter database tempfile '/opt/app/oracle/oradata/orcl/temp01.dbf' online;