Re: Schema

From: Anthony Hogan <USER_at_ANON.JP>
Date: Wed, 26 Sep 2001 12:57:49 +0100
Message-ID: <3BB1C2BD.CF098B16@ANON.JP>

The owner of the schema is the same as the owner of the object.

Choose any object in the schema.
Select owner from all_objects where object_name = '<objectname>'; Result = schema owner.

HTH.
Anthony Hogan

Kennel Yves wrote:
>
> In which table of Oracle7 can I found the owner of the schema ?
> (I would like to execute dbms_utility.analyze_schema on my Oracle
> databases)
Received on Wed Sep 26 2001 - 06:57:49 CDT