Re: Which tables are in which dbspace?

From: Surfer! <nevis-view@nospam.demon.co.uk> > >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. SELECT tabname, dbspace FROM systables, sysfragments WHERE systables.tabid = sysfragments.tabid ORDER BY tabname ...ish. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com