DBA Data[Home] [Help]

VIEW: SYS.EXU8TBPU

Source

View Text - Preformatted

SELECT  "OBJID","DOBJID","BOBJID","OWNERID","PNAME","PROWCNT","PBLKCNT","PAVGRLEN","PFLAGS","PARTNO","HIBOUNDLEN","HIBOUNDVAL","TSNAME","TSNO","FILENO","BLOCKNO","PCTFREE$","PCTUSED$","INITRANS","MAXTRANS","DEFLOG","TSDEFLOG","BLEVEL","LEAFCNT","DISTKEY","LBLKKEY","DBLKKEY","CLUFAC","IFLAGS"
        FROM    sys.exu8tbp
        WHERE   ownerid = userenv('SCHEMAID')
View Text - HTML Formatted

SELECT "OBJID"
, "DOBJID"
, "BOBJID"
, "OWNERID"
, "PNAME"
, "PROWCNT"
, "PBLKCNT"
, "PAVGRLEN"
, "PFLAGS"
, "PARTNO"
, "HIBOUNDLEN"
, "HIBOUNDVAL"
, "TSNAME"
, "TSNO"
, "FILENO"
, "BLOCKNO"
, "PCTFREE$"
, "PCTUSED$"
, "INITRANS"
, "MAXTRANS"
, "DEFLOG"
, "TSDEFLOG"
, "BLEVEL"
, "LEAFCNT"
, "DISTKEY"
, "LBLKKEY"
, "DBLKKEY"
, "CLUFAC"
, "IFLAGS"
FROM SYS.EXU8TBP
WHERE OWNERID = USERENV('SCHEMAID')