Re: Table/Index Names of a User

select table_name from dba_tables

	where owner=upper('&TableOwner')
	order by table_name;
select index_name, table_name
	from dba_indexes
	where owner=upper('&IndexOwner')
	order by index_name;

Bill Bearden
Consultant

Rao Uppuluri <rao_at_sparc10> wrote in article <5lfbet$5d0_at_client2.news.psi.net>...
>
>
> 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"
>
Received on Fri May 16 1997 - 00:00:00 CDT