VIEW: SYS.EXU81IND

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.exu9ind
        WHERE   sysgenconst = 0 AND
                BITAND(property, 1) = 0 OR                     /* not unique */
                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 */
                            ((BITAND(cd$.defer, 8) = 8)))       /* sys gen'd */

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.EXU9IND
WHERE SYSGENCONST = 0 AND BITAND(PROPERTY
, 1) = 0 OR /* NOT UNIQUE */ 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 */ ((BITAND(CD$.DEFER
, 8) = 8))) /* SYS GEN'D */