DBA Data[Home] [Help]

VIEW: SYS.EXU81IXSPU

Source

View Text - Preformatted

SELECT  "OBJID","DOBJID","POBJID","OWNERID","SUBPARTNO","SUBPNAME","TSNAME","FILENO","BLOCKNO","TSNO","PROWCNT","PBLKCNT","PAVGRLEN","BLEVEL","LEAFCNT","DISTKEY","LBLKKEY","DBLKKEY","CLUFAC","HIBOUNDLEN","HIBOUNDVAL","PFLAGS"
        FROM    sys.exu81ixsp
        WHERE   ownerid = userenv('SCHEMAID')
View Text - HTML Formatted

SELECT "OBJID"
, "DOBJID"
, "POBJID"
, "OWNERID"
, "SUBPARTNO"
, "SUBPNAME"
, "TSNAME"
, "FILENO"
, "BLOCKNO"
, "TSNO"
, "PROWCNT"
, "PBLKCNT"
, "PAVGRLEN"
, "BLEVEL"
, "LEAFCNT"
, "DISTKEY"
, "LBLKKEY"
, "DBLKKEY"
, "CLUFAC"
, "HIBOUNDLEN"
, "HIBOUNDVAL"
, "PFLAGS"
FROM SYS.EXU81IXSP
WHERE OWNERID = USERENV('SCHEMAID')