Re: how to list all objects on certain tablespace

  • From: Balakrishna Y <krishna000@xxxxxxxxx>
  • To: mccdba1@xxxxxxxxx
  • Date: Thu, 24 Sep 2009 08:30:23 +0530

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
>
>
>

Other related posts: