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

Home -> Community -> Usenet -> c.d.o.server -> Re: Strange - missing synonyms after export/import

Re: Strange - missing synonyms after export/import

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 19 Nov 2005 21:16:04 +0100
Message-ID: <vu1vn1tp2ciniinpjvju3gh7g0l1baih4d@4ax.com>


On 18 Nov 2005 12:08:12 -0800, "BD" <bobby_dread_at_hotmail.com> wrote:

>I've re-created them all with a gen script, but the question still
>stands - how could 10% of the public synonyms be missing, when they
>were all owned by a schema owner and not a dba/sys schema? I'd think
>that they'd either all be present or all be absent.

Public synonyms are owned by the dummy PUBLIC, NOT by the schema owner.

--
Sybrand Bakker, Senior Oracle DBA
Received on Sat Nov 19 2005 - 14:16:04 CST

Original text of this message

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