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  阅读(354)  评论(0编辑  收藏  举报