Database Administration (MOSC)

MOSC Banner

public synonym for private dblink

edited Mar 30, 2010 9:18PM in Database Administration (MOSC) 7 commentsAnswered
 Hi folks

I've just excuted this

SQL> @cr_dblink_opnsutil_tflt2_rev.sql
SQL> set linesize 200
SQL> conn opnsutil
Enter password:
Connected.
SQL>
SQL> create database link
  2  RTAG.WORLD
  3  connect to &remuser identified by &rempwd using 'ge_tflt1';
Enter value for remuser: rapidtag_admin
Enter value for rempwd: rapidtag_admin
old   3: connect to &remuser identified by &rempwd using 'ge_tflt1'
new   3: connect to rapidtag_admin identified by rapidtag_admin using 'ge_tflt1'

Database link created.

SQL>
SQL> create or replace public synonym "RTAG.WORLD" for RTAG.WORLD;

Synonym created.

but the public synonym it's not working at all

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center