The gateway approach between Oracle 7 and 9 was necessary, since the
procedural option was removed from Oracle 9. The direction of the link
from Oracle 8 to 7 should work. Exp and imp should also work.

Ed Bowers

-----Original Message-----
From: Smith Ron L.
[mailto:oracledba-ezmlmshield-x35378272.[Email address protected]
Sent: Thursday, July 07, 2005 2:02 PM
To: LazyDBA Discussion
Subject: RE: Insert using Select from 7.3.4 to 8.1.7.4 over dblink fails


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.


--------
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


Oracle LazyDBA home page