Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to test a user's dblink as sys user

511874Jun 13 2008 — edited Jun 13 2008
From USER1 I'm able to test the following dblink:
select * from dual@"DBLINK_TEST";

D
-
X

How can I test it as SYS user ?
I was expecting something like...
select * from dual@USER1."DBLINK_TEST";
but it doesn't work.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 11 2008
Added on Jun 13 2008
6 comments
2,491 views