Re: Which tables are in which dbspace?

Posted in 1999

Sujit.Pal@BankAmerica.com — Mon, 10 May 1999 09:47:44 -0700 — source: Informix-list mailing list archive (1991-1998)

Surfer! SELECT tabname, DBINFO('dbspace', HEX(partnum)) FROM systables; HTH Sujit Surfer! <nevis-view@nospam.demon.co.uk> on 05/10/99 02:38:58 AM Please respond to Surfer! <nevis-view@nospam.demon.co.uk> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Which tables are in which dbspace? How can we find out which tables are in which dbspaces, with SQL or onstat or whatever! Of course it should be documented somewhere but there's a gap between theory and practise. Using OL 7.30 on SOLARIS 2.6. -- Surfer!