DBLINK ISSUE
- From: Nagaraj S <nagaraj.chk@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 24 Mar 2011 10:27:19 +0530
Hello Gurus,
DBLINK is working for one particular user, were as it is not working for
other users. Kindly help me to sort out the problem
SQL> select name from v$database;
NAME
---------
A
SQL> show user
USER is "zing"
SQL> select * from dual@xxxxxxxxxxxxx;
D
-
X
where as if i select as sys or any other user i am getting below error
SQL> connect / as sysdba
Connected.
SQL> select * from dual@xxxxxxxxxxxxx;
select * from dual@xxxxxxxxxxxxx
*
ERROR at line 1:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from B
-Naga
Other related posts:
