| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Migration/Refresh tool
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 - 04:22:11 CST
![]() |
![]() |