Re: which tables are in a specific dbspace?

Posted in 1999

Radhika — Fri, 27 Aug 1999 16:20:04 +0500 — source: Informix-list mailing list archive (1991-1998)

Either Use oncheck -pe to monitor disk usage or select b.tabname,d.name from systabextents a,{database Name}:systables b,syschktab c,sysdbstab d where a.te_partnum=b.partnum and b.tabid > 99 and physchunk(te_physaddr) = c.chknum and c.dbsnum = d.dbsnum SR At 09:35 AM 8/27/99 +0200, you wrote: >Hello! > >How can I get, which tables are in a specific dbspace? > >thanks >Gabor > >