Hi, You can also use dba_extents incase if you want to find out residing objects based on every datafile . i would suggest you to read http://tahiti.oracle.com first every things is clearly documented. Regards Bala On Wed, Sep 23, 2009 at 8:56 PM, dba1 mcc <mccdba1@xxxxxxxxx> wrote: > Does anyone know which command can list all objects on certain tablespace? > I have been checked dba_objecrs and dba_tablespaces but not there. > > > > > -- > //www.freelists.org/webpage/oracle-l > > >