追求卓越

create tablespace KZJDIMSdatafile 'E:\KZJDIMS\database\KZJDIMS.DBF'size 32mautoextend on/Create user KZIdentified by KZDefault tablespace KZJDIMS/GRANT  EXP_FULL_DATABASE, IM

查询表空间大小信息select b.file_name ,b.tablespace_name ,b.bytes / 1024 / 1024 ,(b.bytes - sum(nvl(a.bytes, 0))) ,substr((b.bytes - sum(nvl(a.bytes, 0))) / (b.bytes) * 100, 1, 5)  from dba_free_space a,

1.查询时间范围方法：select * from test where to_char(date,'YYYYMMDD') >= '20140101'