db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <rick.hille...@oracle.com>
Subject Re: Trying to determine the space used by tables and indexes in the database
Date Tue, 12 Mar 2013 18:23:48 GMT
Hi Brett,

It seems as though a doc fix was propagated back to 10.8 but the 
corresponding code fix wasn't. The old way of invoking SPACE_TABLE is 
still documented in the 10.4 docs:

SELECT T2.*
     FROM
         SYS.SYSTABLES systabs,
         TABLE (SYSCS_DIAG.SPACE_TABLE(systabs.tablename)) AS T2
     WHERE systabs.tabletype = 'T';

Hope this helps,
-Rick

On 3/12/13 9:22 AM, Bergquist, Brett wrote:
>
> SELECT T2.*
>
> FROM
>
> SYS.SYSTABLES systabs,
>
> TABLE (SYSCS_DIAG.SPACE_TABLE()) AS T2
>
> WHERE systabs.tabletype = 'T'
>
> AND systabs.tableid = T2.tableid;
>


Mime
View raw message