Snowfun

导航

 


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;

posted on 2018-06-10 04:26  Snowfun  阅读(381)  评论(0)    收藏  举报