Tablespace

Hello All

How can I tell what objects are in a particular tablespace eg
select object_name, object_type from xxxx where tablespace_name = xxx

using Oracle 8.0.4.0

TIA Saj Iqbal

--
U-NET Ltd  a VIA NET.WORKS Inc company
Sajid Iqbal                    | Mail : sajid_at_u-net.net
Database DBA/Developer         | Ext  : 4485
U-NET Ltd                      | ICQ  : 43903417
Warrington, Cheshire, UK       |