SELECT t.id, t.owner, t.name, t.isonline, t.content,
CEIL(t.iniext * (t.blocksize / (
SELECT t$.blocksize
FROM sys.ts$ t$
WHERE t$.ts# = 0))),
CEIL(t.sext * (t.blocksize / (
SELECT t$.blocksize
FROM sys.ts$ t$
WHERE t$.ts# = 0))),
t.pctinc, t.minext, t.maxext,
CEIL(t.minlen * (t.blocksize / (
SELECT t$.blocksize
FROM sys.ts$ t$
WHERE t$.ts# = 0))),
t.deflog,
CEIL(t.ext_mgt * (t.blocksize / (
SELECT t$.blocksize
FROM sys.ts$ t$
WHERE t$.ts# = 0))),
t.alloc_type
FROM sys.exu9tbs t
SELECT T.ID
, T.OWNER
, T.NAME
, T.ISONLINE
, T.CONTENT
,
CEIL(T.INIEXT * (T.BLOCKSIZE / (
SELECT T$.BLOCKSIZE
FROM SYS.TS$ T$
WHERE T$.TS# = 0)))
,
CEIL(T.SEXT * (T.BLOCKSIZE / (
SELECT T$.BLOCKSIZE
FROM SYS.TS$ T$
WHERE T$.TS# = 0)))
,
T.PCTINC
, T.MINEXT
, T.MAXEXT
,
CEIL(T.MINLEN * (T.BLOCKSIZE / (
SELECT T$.BLOCKSIZE
FROM SYS.TS$ T$
WHERE T$.TS# = 0)))
,
T.DEFLOG
,
CEIL(T.EXT_MGT * (T.BLOCKSIZE / (
SELECT T$.BLOCKSIZE
FROM SYS.TS$ T$
WHERE T$.TS# = 0)))
,
T.ALLOC_TYPE
FROM SYS.EXU9TBS T
|
|
|