Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: catalog/catproc as system

Re: catalog/catproc as system

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 15 Aug 2005 13:53:22 -0700
Message-ID: <1124139202.243614.78020@z14g2000cwz.googlegroups.com>


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 -- Received on Mon Aug 15 2005 - 15:53:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US