Re: Table/Index Names of a User

Rao Uppuluri wrote:
>
> Hi
>
> I am using Oracle 7.3.2 for Solaris. I am new to Oracle and I am
> wondering if there is a way to know the table_names and index_names
> that a users owns from the system tables through a query.
> Any help is greatly appreciated.
>
> Thank you in advance
>
> Rao Uppuluri
>
> --
> /************************************************************/
> Rao Uppuluri : rao_at_intsec.com
> "All generalizations are wrong"

Try SELECT OWNER,SEGMENT_NAME,SEGMENT_TYPE,TABLESPACE_NAME

      FROM DBA_SEGMENTS
     WHERE OWNER NOT IN ('SYS','SYSTEM')
      ORDER BY OWNER, SEGMENT_TYPE,SEGMENT_NAME;

You need to have dba priv or log in as system to use dba prefixed tables. You can substitute ALL_SEGMENTS for DBA_SEGMENTS.

Dick Allie - dallie_at_ionet.net Received on Wed May 21 1997 - 00:00:00 CDT