SELECT s."LOG_OWNER",s."LOG_OWNERID",s."MASTER",s."LOG_TABLE",s."LOG_TRIGGER",s."FLAG",s."YOUNGEST",s."OLDEST",s."OLDEST_PK",s."MTIME",s."ROWID_SNAPL",s."PRIMKEY_SNAPL",s."OID_SNAPL",s."SEQ_SNAPL",s."INV_SNAPL",s."FILE_VER",s."TEMP_LOG",s."OLDEST_OID",s."OLDEST_NEW"
FROM sys.exu9snapl s, sys.incexp i, sys.incvid v
WHERE s.master = i.name(+) AND
s.log_ownerid = i.owner#(+) AND
NVL(i.type#, 98) = 98 AND
(NVL(i.ctime, TO_DATE('01-01-1900', 'DD-MM-YYYY')) < i.itime OR
NVL(i.expid, 9999) > v.expid)
SELECT S."LOG_OWNER"
, S."LOG_OWNERID"
, S."MASTER"
, S."LOG_TABLE"
, S."LOG_TRIGGER"
, S."FLAG"
, S."YOUNGEST"
, S."OLDEST"
, S."OLDEST_PK"
, S."MTIME"
, S."ROWID_SNAPL"
, S."PRIMKEY_SNAPL"
, S."OID_SNAPL"
, S."SEQ_SNAPL"
, S."INV_SNAPL"
, S."FILE_VER"
, S."TEMP_LOG"
, S."OLDEST_OID"
, S."OLDEST_NEW"
FROM SYS.EXU9SNAPL S
, SYS.INCEXP I
, SYS.INCVID V
WHERE S.MASTER = I.NAME(+) AND
S.LOG_OWNERID = I.OWNER#(+) AND
NVL(I.TYPE#
, 98) = 98 AND
(NVL(I.CTIME
, TO_DATE('01-01-1900'
, 'DD-MM-YYYY')) < I.ITIME OR
NVL(I.EXPID
, 9999) > V.EXPID)
|
|
|