本文共 824 字,大约阅读时间需要 2 分钟。
SELECT upper(f.tablespace_name) 表空间名,
d.Tot_grootte_Mb "表空间大小(M)", d.Tot_grootte_Mb - f.total_bytes "已使用空间(M)", round((d.Tot_grootte_Mb - f.total_bytes) / d.Tot_grootte_Mb * 100,2) "使用比", f.total_bytes "空闲空间(M)", f.max_bytes "最大块(M)" FROM (SELECT tablespace_name, round(SUM(bytes)/(1024*1024),2) total_bytes, round(MAX(bytes)/(1024*1024),2) max_bytes FROM sys.dba_free_space GROUP BY tablespace_name) f, (SELECT dd.tablespace_name, round(SUM(dd.bytes)/(1024*1024),2) Tot_grootte_Mb FROM sys.dba_data_files dd GROUP BY dd.tablespace_name) d WHERE d.tablespace_name = f.tablespace_name ORDER BY 4 DESCCREATE USER username IDENTIFIED BY "123456" DEFAULT TABLESPACE xxx_tab_spce;
grant connect ,resource,dba to username;
create table temp(
id varchar2(10) not null ); select * from temp a;转载地址:http://halmd.baihongyu.com/