I am doing this, using the 8.1.7 database as a "gateway" to a 9.2
database from an old 7.3.4 database.
I created a synonym in the 7.3.4 db which includes the Dblink info. It
works fine. Slow, but fine.

Ron

-----Original Message-----
From: Michael Porter
[mailto:oracledba-ezmlmshield-x59713793.[Email address protected]
Sent: Thursday, July 07, 2005 2:58 PM
To: LazyDBA Discussion
Subject: Insert using Select from 7.3.4 to 8.1.7.4 over dblink fails


I am trying to do an insert from a 734 db to an 8174 db over a dblink
using select and am getting:

my suedo sql is:
insert into [Email Address Removed] (.....)
select .... from whatever;

which results in:

INSERT INTO apps.[Email Address Removed] at line 1:
ORA-00920: invalid relational operator
ORA-02063: preceding line from PRD7
ORA-02063: preceding 2 lines from ORAFINAPPS



I see hits on metalink but, they seem to relate to using "not in" for
the select;s where clause which I am not.

Ideas???

Mike



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Important Notice!!
If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited.
Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message.
Thank you.

Oracle LazyDBA home page