SELECT t."OBJID",t."NAME",t."OWNER",t."OWNERID",t."TABLESPACE",t."FILENO",t."BLOCKNO",t."AUDIT$",t."COMMENT$",t."CLUSTERFLAG",t."MTIME",t."MODIFIED",t."PCTFREE$",t."PCTUSED$",t."INITRANS",t."MAXTRANS",t."PARALLEL",t."CACHE" from exu7tab t,incexp i, incvid v
WHERE t.name = i.name(+) AND t.ownerid = i.owner#(+) AND
NVL(i.type#,2) = 2 AND
(bitand(t.modified,1) = 1 OR t.mtime > i.itime OR
NVL(i.expid,9999) > v.expid)
SELECT T."OBJID"
, T."NAME"
, T."OWNER"
, T."OWNERID"
, T."TABLESPACE"
, T."FILENO"
, T."BLOCKNO"
, T."AUDIT$"
, T."COMMENT$"
, T."CLUSTERFLAG"
, T."MTIME"
, T."MODIFIED"
, T."PCTFREE$"
, T."PCTUSED$"
, T."INITRANS"
, T."MAXTRANS"
, T."PARALLEL"
, T."CACHE"
FROM EXU7TAB T
, INCEXP I
, INCVID V
WHERE T.NAME = I.NAME(+)
AND T.OWNERID = I.OWNER#(+) AND
NVL(I.TYPE#
, 2) = 2
AND
(BITAND(T.MODIFIED
, 1) = 1 OR T.MTIME > I.ITIME OR
NVL(I.EXPID
, 9999) > V.EXPID)
|
|
|