ORACLE基础命令集：数据操作与管理

imp saas/saas@orcl file=c:\saas.dmp ignore=y fromuser=saas touser=saas log=C:\saas.log
exp saas/saas@orcl file=d:\saas.dmp  log=d:\saas.log
exp saas/saas@orcl file=d:\saas.dmp  log=d:\saas.log FULL=Y

select name from v$datafile;
create  tablespace  表空间名  datafile  '对应的文件名'  size  XXXM;


1. 查看所有表空间大小
select tablespace_name,sum(bytes)/1024/1024 from dba_data_files group by tablespace_name;    

2. 未使用的表空间大小
select tablespace_name,sum(bytes)/1024/1024 from dba_free_space group by tablespace_name;

3. 还有在命令行情况下如何将结果放到一个文件里。 
SQL> spool out.txt    
SQL> select * from v$database;    
SQL> spool off 

4.查询所有的表空间
select tablespace_name from dba_tablespaces   

5.查看表空间中分布的用户信息
select tablespace_name, owner,sum(bytes) from dba_segments group by tablespace_name, owner

6.查看表空间已经使用的百分比
select    a.tablespace_name,a.bytes/1024/1024 "Sum MB",(a.bytes-b.bytes)/1024/1024   "used MB",b.bytes/1024/1024 "free MB",round(((a.bytes-b.bytes)/a.bytes)*100,2) "percent_used"   
from (select tablespace_name,sum(bytes) bytes from dba_data_files group by tablespace_name) a,(select tablespace_name,sum(bytes) bytes,max(bytes) largest from dba_free_space group by tablespace_name) b    
where    a.tablespace_name=b.tablespace_name    
order   by    ((a.bytes-b.bytes)/a.bytes)   desc