Re: Table/Index Names of a User

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1997/05/17
Message-ID: <337D3C5F.4E6A@postoffice.worldnet.att.net>#1/1

SELECT object_name, object_type
FROM user_objects
WHERE object_type IN ('TABLE', 'INDEX')
ORDER BY object_type DESC, object_name;

I hope this helps.

Michael Serbanescu

---

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"
Received on Sat May 17 1997 - 00:00:00 CDT