读书人

求条sql语句解决方法

发布时间: 2012-02-23 22:01:36 作者: rapoo

求条sql语句,
查找用户user1下创建日期为当天的表大小!

[解决办法]

SQL code
上面是用户自己执行时的,如果想看别人的,执行如下:SELECT t.bytes  FROM DBA_Segments T,       (SELECT object_name          FROM DBA_OBJECTS S         WHERE TRUNC(S.CREATED) = TRUNC(SYSDATE)           AND OBJECT_TYPE = 'TABLE'           and owner='USER1') VWHERE t.segment_name=v.object_name      and owner='USER1'; 

读书人网 >oracle

热点推荐