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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Migration/Refresh tool

Re: Migration/Refresh tool

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Sat, 07 Jan 2006 11:22:11 +0100
Message-ID: <jg5vr1taul2ktb6tql630miiun2af20mft@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 DBA
Received on Sat Jan 07 2006 - 04:22:11 CST

Original text of this message

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