db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bergquist, Brett" <BBergqu...@canoga.com>
Subject Trying to determine the space used by tables and indexes in the database
Date Tue, 12 Mar 2013 16:22:15 GMT
Derby is 18.8.   From the Derby 10.8 reference manual, I fiind:

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


If I try to run that, I get:

Error: No constructor was found with the signature org.apache.derby.diag.SpaceTable().  It
may be that the parameter types are not method invocation convertible.
SQLState:  42X75
ErrorCode: -1

Any ideas on how to run that to get the space used by each table/index?



Mime
View raw message