Re: Help! Schemas

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Tue, 06 Jul 1999 13:58:48 -0400
Message-ID: <378243D8.26947EEA@Unforgettable.com>

select owner||'.'||table_name, table_type from all_catalog where owner = 'xxx'
(use the schema you are after in place of the xxx).

Ken

sjoshi_at_ingr.com wrote:

> Could anyone please tell me, how do I get a list of all the objects
> (tables, etc) in a schema. I can log in as manager and have access to
> that schema.
>
> thanks
> Sunit
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Tue Jul 06 1999 - 12:58:48 CDT