随风的博客

select OWNER, t.segment_name, t.segment_type, sum(t.bytes / 1024 / 1024) mmmfrom dba_segments twhere t.owner = '用户名'and t.segment_type='TABLE'and t.segment_name='表名'group by OWNER, t.segment_name, t.s...

查看表空间select t.* from dba_data_files t;查看用户表空间放置的位置select name from v$datafile;select status,fuzzy,tablespace_name,name from v$datafile_header;创建表空间create tablespace ODSloggingdatafile 'E:\Develop\app\...

to_timestamp(to_char(trunc(systimestamp - 2 - to_char(systimestamp - 1, 'd')),'yyyy-mm-dd')||' 15:00:00','yyyy-mm-dd hh24:mi:ss')to_timestamp(to_char(trunc(systimestamp + 5 - to_char(systimestamp - 1,...

查询刚过去一段时间的数据变更情况select * from T_EVENT versions between timestamp to_date('2017-09-28 15:24','yyyy-mm-dd hh24:mi') and sysdate;