| ORA-02019: connection description for remote database not found [message #57961] |
Tue, 22 July 2003 15:38 |
Avnish Thakur
Messages: 1
Registered: July 2003
|
Junior Member |
|
|
When i try to describe a table in remote D.B i get the following error:
SQL> desc tnv_sys_synch_y
ERROR:
ORA-02019: connection description for remote database not found
BUT ANY QUERY ON THE TABLE IS SUCCESSFULL:
SQL> select count(*) from tnv_sys_synch_y;
COUNT(*)
----------
0
Here tnv_sys_synch_y is a private synonym to the table in the remote DB. If i use the fully qualified name of the table then i can describe it.
SQL> desc pans.tnv_sys_synch_t@UPANWS03_BPA_UPD;
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
SYS_ID NOT NULL NUMBER(3)
NPA NOT NULL NUMBER(3)
NXX NOT NULL NUMBER(3)
LINE_X NOT NULL NUMBER(1)
LINE NOT NULL NUMBER(4)
SYS_STAT_CD NOT NULL NUMBER(2)
LASTUPD NOT NULL DATE
What seems to be the problem with synonym. Why can't i describe the table through the synonym.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
