Re: Migration/Refresh tool
From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Sat, 07 Jan 2006 11:22:11 +0100
Message-ID: <jg5vr1taul2ktb6tql630miiun2af20mft_at_4ax.com>
Date: Sat, 07 Jan 2006 11:22:11 +0100
Message-ID: <jg5vr1taul2ktb6tql630miiun2af20mft_at_4ax.com>
On 6 Jan 2006 18:16:06 -0800, "Magnus Andersen" <mag.andersen_at_gmail.com> wrote:
> When I now try to create a
>synynom for that table called ps_cm_prodcost will not the database
>error and tell me that there is already a synonym with that name?
Reading the docs, you would have noticed there are *private* and
*public* synonyms, differentiated by the
create [public] synonym command,
so by default all synonyms are private to a schema.
-- Sybrand Bakker, Senior Oracle DBAReceived on Sat Jan 07 2006 - 11:22:11 CET