It would be good if the sample query for SYSCS_DIAG.SPACE_TABLE also showed the schema name as that will be required by SYSCS_UTIL.SYSCS_COMPRESS_TABLE if the tables are compressed.
The doc page as at:
The query for all tables and indexes could be:
SELECT sysschemas.schemaname, T2.*
SYS.SYSTABLES systabs, SYS.SYSSCHEMAS sysschemas,
TABLE (SYSCS_DIAG.SPACE_TABLE()) AS T2
WHERE systabs.tabletype = 'T'
AND sysschemas.schemaid = systabs.schemaid
AND systabs.tableid = T2.tableid;