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')
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')
|
|
|