ORA-2085: Database link error

ORA-2085: Database link error

Post by senthi » Sun, 31 Dec 1899 09:00:00



Hi there,
i have created database link in production database to link standby
database. when i try to issue query using link, it gives ora-2085
error. what could be the problem.
Thanks for your help.
senthil.

Sent via Deja.com http://www.deja.com/
Before you buy.

 
 
 

ORA-2085: Database link error

Post by Troy Tinne » Sun, 31 Dec 1899 09:00:00


Are you using a synonym for the database link? How are you executing the
query? What is the name or connect string (if not a synonym) you are
using? Hard to tell what the problem is without some more info.

Regards,
Troy


> Hi there,
> i have created database link in production database to link standby
> database. when i try to issue query using link, it gives ora-2085
> error. what could be the problem.
> Thanks for your help.
> senthil.

> Sent via Deja.com http://www.deja.com/
> Before you buy.


 
 
 

1. ORA-2085: Database link error

Hi there,
i have created database link in production database to link standby
database. When i try to issue query using link, it gives ora-2085
error. what could be the problem.
Thanks for your suggestion.
senthil.

Sent via Deja.com http://www.deja.com/
Before you buy.

2. Number of rows in BulkCopy datafile

3. error ora 2085

4. How to get SQL CE ?

5. error 2085 - Db link oracle 8.1.5

6. a hard one!

7. BTRIEVE Error 2085

8. ORA-12666 error w/database link

9. database link - error ORA-02085 problem

10. Creat a database link to Remote Database: ORA-02085

11. newbie.errors on database connection ORA-1157,ORA-01034

12. Create new DB errors (ORA-01610, ORA-01194, ORA-01110)