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."FILE_VER"
FROM sys.exu8snapl s, sys.incexp i, sys.incvid v
WHERE s.master = i.name(+) AND
s.log_ownerid = i.owner#(+) AND
/* snapshot log also creates a table with the same name */
NVL(i.type#, 98) IN (2, 98) AND
(s.mtime > 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."FILE_VER"
FROM SYS.EXU8SNAPL S
, SYS.INCEXP I
, SYS.INCVID V
WHERE S.MASTER = I.NAME(+) AND
S.LOG_OWNERID = I.OWNER#(+) AND
/* SNAPSHOT LOG ALSO CREATES A TABLE WITH THE SAME NAME */
NVL(I.TYPE#
, 98) IN (2
, 98) AND
(S.MTIME > I.ITIME OR
NVL(I.EXPID
, 9999) > V.EXPID)
|
|
|