Re: Table/Index Names of a User

From: <seci_at_ludens.elte.hu>
Date: 1997/05/26
Message-ID: <1997May26.145743.40667@ludens>#1/1

hi,

In article <5lfbet$5d0_at_client2.news.psi.net>, rao_at_sparc10 (Rao Uppuluri) writes:
> 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.
use the views

	user_tables and
	user_indexes

> Any help is greatly appreciated.
>
> Thank you in advance
>
> Rao Uppuluri
>
> --
> /************************************************************/
> Rao Uppuluri : rao_at_intsec.com
> "All generalizations are wrong"
HTH
        peter Received on Mon May 26 1997 - 00:00:00 CDT