| ORA-02019: connection description for remote database not found [message #141587] |
Tue, 11 October 2005 02:00  |
sanaafridi
Messages: 50
Registered: August 2005
Location: pakistan
|
Member |
 
|
|
hi all
i am trying to populate a table from another db server in LAN enviorment and i use the following statement.
insert into rg_ca_category (candidate_id,st_cat_code,session_id,cate_roll_no,cand_name,f_h_name,sex,dob,id_card_no,perm_address,curr_address,perm_phone,curr_pho ne,e_mail,remarks,user_id,user_dt)
select candidate_id,st_cat_code,
session_id,cate_roll_no,cand_name,f_h_name,sex,dob,id_card_no,perm_address,curr_address,perm_phone,curr_phone,e_mail,remarks,user_id, user_dt from nust.rg_ca_category@nustdb;
but it give the following error
ORA-02019: connection description for remote database not found
now what i know about this error is that to check the tnsnames.ora file whic is i checked and quite right and it must be as i am connected to that server but then why this error message.
the other server have oracle 8.1.5 and my machine have ora 9.2
so any clue ??
regards
sana
|
|
|
|
| Re: ORA-02019: connection description for remote database not found [message #142348 is a reply to message #141587] |
Fri, 14 October 2005 04:52  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Is nustdb is a database link ?
If so,What kind of database link did you created ?
Who is the owner of the database link ?
Are you running this command from the same session where this link was created ?
see this ,
SQL> show user;
USER is "TANU"
SQL> select * from user_db_links;
DB_LINK USERNAME
----------------------------------------------------------------------------------------------------
HOST
----------------------------------------------------------------------------------------------------
CREATED
---------
LINK1 SCOTT
srvc_sun_us
08-SEP-05
SQL> select * from emp@link1;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- ----------
7369 SMITH CLERK 7902 17-DEC-80 800 20
7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30
7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30
7566 JONES MANAGER 7839 02-APR-81 2975 20
7839 KING PRESIDENT 17-NOV-81 5000 10
7844 TURNER SALESMAN 7698 08-SEP-81 1500 0 30
7876 ADAMS CLERK 7788 23-MAY-87 1100 20
7900 JAMES CLERK 7698 03-DEC-81 950 30
7902 FORD ANALYST 7566 03-DEC-81 3000 20
7934 MILLER CLERK 7782 23-JAN-82 1300 10
10 rows selected.
SQL> show user
USER is "SCOTT"
SQL> select * from emp@link1;
select * from emp@link1
*
ERROR at line 1:
ORA-02019: connection description for remote database not found
SQL> show user;
USER is "SYS"
SQL> select * from emp@link1;
select * from emp@link1
*
ERROR at line 1:
ORA-02019: connection description for remote database not found
It looks that the database link is private database link , so try to login as the user who created this dblink and then try to run this command . read more about DBLINKS from
here
regards,
tarun
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
