VIEW: SYS.EXU9INDIC

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               /* not sys gen constraints */
                (bitmap = 1 OR                             /* select bitmap, */
                 BITAND(property, 16) = 16 OR                 /* functional, */
                 type = 9) AND                         /* and domain indexes */
                (iownerid, btname) IN ((
                    SELECT  i.owner#, i.name
                    FROM    sys.incexp i, sys.incvid v
                    WHERE   i.expid > v.expid AND
                            i.type# = 2)
                  UNION (
                    SELECT  r.ownerid, r.tname
                    FROM    sys.incexp ii, sys.incvid vv, sys.exu8ref r
                    WHERE              /*refs a table included in the export */
                            r.rtname = ii.name AND
                            r.rownerid = ii.owner# AND
                            ii.expid > vv.expid AND
                            ii.type# = 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.EXU9IND
WHERE SYSGENCONST = 0
AND /* NOT SYS GEN CONSTRAINTS */ (BITMAP = 1 OR /* SELECT BITMAP
, */ BITAND(PROPERTY
, 16) = 16 OR /* FUNCTIONAL
, */ TYPE = 9)
AND /*
AND DOMAIN INDEXES */ (IOWNERID
, BTNAME) IN (( SELECT I.OWNER#
, I.NAME
FROM SYS.INCEXP I
, SYS.INCVID V
WHERE I.EXPID > V.EXPID AND I.TYPE# = 2) UNION ( SELECT R.OWNERID
, R.TNAME
FROM SYS.INCEXP II
, SYS.INCVID VV
, SYS.EXU8REF R
WHERE /*REFS A TABLE INCLUDED IN THE EXPORT */ R.RTNAME = II.NAME AND R.ROWNERID = II.OWNER# AND II.EXPID > VV.EXPID AND II.TYPE# = 2))