Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: database link as user PUBLIC
Did the message 'missing or invalid username' give you a clue? PUBLIC is not a user ( at least in the normal sense )....
"bernhard labus" <bernhard.labus_at_home.ins.de> wrote:
>Hello everybody,
>
>maybe someone knows:
>How can I create a database link as user PUBLIC,
>***I don't mean*** a public database link.
>
>I am on database A and want to query a public synonym on database B.
>when I try
>create database link LINKTOBasPUBLIC connect to PUBLIC using 'B',
>ORA-00987: missing or invalid username(s)
>or
>create database link LINKTOBasPUBLIC connect to PUBLIC identified externally
>using 'B',
>ORA-00987: missing or invalid username(s)
>
>Thanx in advance
>Bernhard
>
Received on Tue Jan 02 2001 - 09:51:37 CST