VIEW: SYS.EXU11IND

Source

View Text - Preformatted

SELECT  "IOBJID","IDOBJID","INAME","IOWNER","IOWNERID","ISPACE","ITSNO","IFILENO","IBLOCKNO","BTNAME","BTOBJID","BTOWNER","BTOWNERID","BTPROPERTY","BTCLUSTERFLAG","PROPERTY","CLUSTER$","PCTFREE$","INITRANS","MAXTRANS","BLEVEL","BITMAP","DEFLOG","TSDEFLOG","DEGREE","INSTANCES","TYPE","ROWCNT","LEAFCNT","DISTKEY","LBLKKEY","DBLKKEY","CLUFAC","PRECCNT","IFLAGS","SYSGENCONST"
        FROM    sys.exu11ind_base
        WHERE   NOT EXISTS (
                    SELECT  *
                    FROM    sys.con$ c$, sys.cdef$ cd$
                    WHERE   c$.name = iname AND   /* same name as constraint */
                            c$.owner# = iownerid AND
                            c$.con# = cd$.con# AND
                            NVL(cd$.enabled, 0) = iobjid AND  /* cons enable */
                            (cd$.intcols = 1 AND           /* single column */
                             EXISTS (
                                SELECT  *
                                FROM    sys.ccol$ cc$, sys.col$ co$
                                WHERE   cc$.con# = c$.con# AND
                                        co$.obj# = cc$.obj# AND
                                        co$.intcol# = cc$.intcol# AND
                                        BITAND(co$.property, 2) = 2)))

View Text - HTML Formatted

SELECT "IOBJID"
, "IDOBJID"
, "INAME"
, "IOWNER"
, "IOWNERID"
, "ISPACE"
, "ITSNO"
, "IFILENO"
, "IBLOCKNO"
, "BTNAME"
, "BTOBJID"
, "BTOWNER"
, "BTOWNERID"
, "BTPROPERTY"
, "BTCLUSTERFLAG"
, "PROPERTY"
, "CLUSTER$"
, "PCTFREE$"
, "INITRANS"
, "MAXTRANS"
, "BLEVEL"
, "BITMAP"
, "DEFLOG"
, "TSDEFLOG"
, "DEGREE"
, "INSTANCES"
, "TYPE"
, "ROWCNT"
, "LEAFCNT"
, "DISTKEY"
, "LBLKKEY"
, "DBLKKEY"
, "CLUFAC"
, "PRECCNT"
, "IFLAGS"
, "SYSGENCONST"
FROM SYS.EXU11IND_BASE
WHERE NOT EXISTS ( SELECT *
FROM SYS.CON$ C$
, SYS.CDEF$ CD$
WHERE C$.NAME = INAME
AND /* SAME NAME AS CONSTRAINT */ C$.OWNER# = IOWNERID AND C$.CON# = CD$.CON# AND NVL(CD$.ENABLED
, 0) = IOBJID
AND /* CONS ENABLE */ (CD$.INTCOLS = 1
AND /* SINGLE COLUMN */ EXISTS ( SELECT *
FROM SYS.CCOL$ CC$
, SYS.COL$ CO$
WHERE CC$.CON# = C$.CON# AND CO$.OBJ# = CC$.OBJ# AND CO$.INTCOL# = CC$.INTCOL# AND BITAND(CO$.PROPERTY
, 2) = 2)))