Oracle-日常运维-删除临时文件回收空间

 一需求、  为什么删除了临时文件，但是v$tempfile,dba_temp_files视图中还是存在记录

alter tablespace cc drop tempfile '/xxx';
Mon Apr 19 14:26:56 2021
alter tablespace cc drop tempfile '/xxx'
Completed: alter tablespace cc drop tempfile 'xxx'

SYS>select file_name,file_id,TABLESPACE_NAME,BYTES/1024/1024/1024,AUTOEXTENSIBLE,maxbytes/1024/1024/1024 from
 dba_temp_files where tablespace_name='cc';
FILE_NAME        FILE_ID TABLESPACE_NAME            
-------------------------------------------------- 
xxx                 1     cc
SYS>select * from v$tempfile;
     FILE# CREATION_CHANGE# CREATION_TIME          TS#     RFILE# STATUS  ENABLED         BYTES     BLOCKS CREATE_BYTES BLOCK_SIZE NAME
---------- ---------------- --------------- ---------- ---------- ------- ---------- ---------- ---------- ------------ ---------- 
         1             3205 23-NOV-14                3          1 OFFLINE READ WRITE          0          0   2097152000       8192 xxx
　　

 

二、语法不正确

 

SQL> alter tablespace cc drop tempfile 1;