OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » ora-02070 (10.2.0.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-02070 [message #553689]

Mon, 07 May 2012 21:09

lerry_wu
Messages: 12
Registered: December 2011

Junior Member

dblink:MS_LCR oracle link to sqlserver 2005
sql:

select a.* from log_Board_parts@ms_lcr a , reeldata@ms_lcr b where a."sReelId"=b."sReelId"(+);

error:
ora-02070 database MS_LCR does not support outer join in this context

how to slove this problem !!

Report message to a moderator

Re: ora-02070 [message #553690 is a reply to message #553689]

Mon, 07 May 2012 21:12

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

bcm@bcm-laptop:~$ oerr ora 2070
02070, 00000, "database %s%s does not support %s in this context"
// *Cause: The remote database does not support the named capability in
//	   the context in which it is used.
// *Action: Simplify the SQL statement.
//

Report message to a moderator

Re: ora-02070 [message #553692 is a reply to message #553689]

Tue, 08 May 2012 00:35

Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Create a view in the remote database matching this query and query the remote view.

Regards
Michel

Report message to a moderator

Previous Topic:	like operator
Next Topic:	Restriction in Date Range

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Aug 30 15:16:09 CDT 2025