DBA Data[Home] [Help]

VIEW: SYS.EXU8PSTIC

Source

View Text - Preformatted

SELECT  "OWNER","OWNERID","TNAME","TOBJID","CALLORDER","CALLARG","OBJTYPE","USRARG","PROPERTY"
        FROM    sys.exu8pst
        WHERE   (ownerid, tname) IN (
                    SELECT  i.owner#, i.name
                    FROM    sys.incexp i, sys.incvid v
                    WHERE   i.expid > v.expid AND
                            i.type# = 2)
View Text - HTML Formatted

SELECT "OWNER"
, "OWNERID"
, "TNAME"
, "TOBJID"
, "CALLORDER"
, "CALLARG"
, "OBJTYPE"
, "USRARG"
, "PROPERTY"
FROM SYS.EXU8PST
WHERE (OWNERID
, TNAME) IN ( SELECT I.OWNER#
, I.NAME
FROM SYS.INCEXP I
, SYS.INCVID V
WHERE I.EXPID > V.EXPID AND I.TYPE# = 2)