alter tablespace TEMP add tempfile ‘/data/oracle/oradata/orcl/temp02.dbf‘ size 100m autoextend on;
alter tablespace TEMP drop tempfile ‘/data/oracle/oradata/orcl/temp01.dbf‘;
select FILE_NAME,STATUS,AUTOEXTENSIBLE from dba_temp_files;
SELECT * FROM dba_tablespaces;
EHR ORA--1187由于验主频雘失败而无法从文件读取 ORA-01110数据文件temp01.dbf
原文：https://www.cnblogs.com/Snowfun/p/9162091.html