| database link problem [message #53569] |
Sun, 29 September 2002 21:26  |
jag
Messages: 15
Registered: July 2002
|
Junior Member |
|
|
Hi All,
I have got 2 databases one of Oracle7.3 and the other of Oracle8.1.6. I have created dababase links for a user X present on both the databases.
When I describe a table TST from the Oracle7 database, the table is gets described after, setting the global names= false.
but if I try the same from the Oracle8 database it gives an error of connection description..
but if I issue a select statement from the 8 database it selects records.....
Why is it so ?
Thanks.
From Oracle7 :- (global_names = true)
SQL> alter session set global_names = false;
SQL> desc tst@linkfrom7to8
Name Null? Type
------------------------------- -------- ----
NO NUMBER(2)
SQL> select * from tst@linkfrom7to8;
NO
----------
8
*******************
From Oracle8 :- (global_names = False )
SQL>desc tst@linkfrom8to7
ERROR:
ORA-02019: connection description for remote database not found
SQL>select * from tst@linkfrom8to7;
NO
----------
7
|
|
|
|
| Re: database link problem [message #53606 is a reply to message #53569] |
Tue, 01 October 2002 10:35  |
Zeeshan ,
Messages: 1
Registered: October 2002
|
Junior Member |
|
|
You might be hitting a Bug.
workaround....
Create a view on the tablename@linkfrom8to7 and then describe the view.
SQL> Create view as test_view as select * from tablename@linkfrom8to7;
View created
SQL > desc test_view;
worked.
--Cheers,
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
