Re: catalog/catproc as system

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Mon, 15 Aug 2005 23:54:19 GMT
Message-ID: <LW9Me.1530$PM3.1411@twister.nyroc.rr.com>

Mark D Powell wrote:
> Look at dba_objects for objects that exist both under user SYS and user
> SYSTEM. Drop the SYSTEM owned version.
>
> Check that the public synonyms for the dictionary objects all point to
> the SYS owned version and not to a SYSTEM owned version.
>
> Rerun catexp as user SYS.
>
> HTH -- Mark D Powell --
>

Beware though, there are some objects related to replication which should be duplicated under SYS and SYSTEM.

See metalink note: 1030426.6 for details.

IIRC: oracle's 10gR2 catalog and catproc scripts now have an explicit check about them being run as SYS.

HTH Anurag Received on Mon Aug 15 2005 - 18:54:19 CDT