DBA Data[Home] [Help]

VIEW: SYS.EXU9PDSU

Source

View Text - Preformatted

SELECT  "OBJID","TYPE","OWNERID","PTYPE","SUBPTYPE","PFLAG","PCNT","PKCNT","PCTFREE$","PCTUSED$","INITRANS","MAXTRANS","INIEXTS","EXTSIZE","MINEXTS","MAXEXTS","EXTPCT","FLISTS","FREEGRP","TSNAME","DEFLOG","PCACHE","BLOCKSIZE","HSCOMPRESS","DEFSUBPCNT","MAXSIZE"
        FROM    sys.exu9pds
        WHERE   ownerid = userenv('SCHEMAID')
View Text - HTML Formatted

SELECT "OBJID"
, "TYPE"
, "OWNERID"
, "PTYPE"
, "SUBPTYPE"
, "PFLAG"
, "PCNT"
, "PKCNT"
, "PCTFREE$"
, "PCTUSED$"
, "INITRANS"
, "MAXTRANS"
, "INIEXTS"
, "EXTSIZE"
, "MINEXTS"
, "MAXEXTS"
, "EXTPCT"
, "FLISTS"
, "FREEGRP"
, "TSNAME"
, "DEFLOG"
, "PCACHE"
, "BLOCKSIZE"
, "HSCOMPRESS"
, "DEFSUBPCNT"
, "MAXSIZE"
FROM SYS.EXU9PDS
WHERE OWNERID = USERENV('SCHEMAID')