Re: Help! Schemas

From: <tedchyn_at_yahoo.com>
Date: Tue, 06 Jul 1999 17:22:54 GMT
Message-ID: <7lte0v$jpp$1@nnrp1.deja.com>

sunit, try
select object_name,object_type,status, ... from sys.dba-objects
where owner=<schema owner>

Ted chyn
In article <7ltd4m$je8$1_at_nnrp1.deja.com>, 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.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jul 06 1999 - 12:22:54 CDT