摘要：
1 select 2 b.file_id FILEID, 3 b.tablespace_name TBSNAME, 4 b.bytes/1024/1024||'M' SIZES, 5 (b.bytes-sum(nvl(a.bytes,0)))/1024/1024||'M' USED, 6 sum(nvl(a.bytes,0))/1024/1024||'M' FREE, 7 100 - sum(nvl(a.bytes,0))/(b.bytes)*100||'%' PERCENTS 8 from dba_free_space a, 9 阅读全文
摘要：
--创建临时表空间create temporary tablespace data_temptempfile 'D:\oracle\oraudata\data_temp.dbf'size 2000mautoextend onnext 500mextent management local;--创建数 阅读全文