日期:2014-05-16  浏览次数:20498 次

oracle查看表空间剩余
SELECT tablespace_name 表空间,round( sum(blocks * 8192 / 1000000)/1024 ,3 ) 剩余空间G
  FROM dba_free_space
 GROUP BY tablespace_name
 order by 剩余空间G;
 
 ---------------------------------------------
 --解决临时表空间不足问题。
  select username,default_tablespace,temporary_tablespace
  from dba_users
  where username='CTLTMP';
  
  
  select file_name,tablespace_name
  from dba_data_files
  where tablespace_name='CTL';
   
   
  create TEMPORARY tablespace TEMPBI TEMPFILE 'F:\oradata\TEMPBI01.dbf' size 30G REUSE;
  
  ALTER USER stg TEMPORARY TABLESPACE TEMPBI;
  ALTER USER mdm TEMPORARY TABLESPACE TEMPBI;
  ALTER USER ctl TEMPORARY TABLESPACE TEMP;