Dick,
So what should be the solution? Does it mean that we should not try to insert multiple
rows across database link?
I also tried inline view but it didn't help.
Any help is appreciated.
Ashoke
-Original Message-
Sent: Monday, April 22, 2002 5:13 PM
To: Multiple recipients of list
Ashoke,
The solution needs to be tailored to the application, which I'm sure is not
the answer you want. We do have tables that are accessed via database links
here and we do a substantial amount of work just to prevent some, but not all,
of this. My basic approach is that if the remote
Greetings,
Here is the scenario.
We are trying to insert records into a remote table via database link after selecting
the data locally.
This query hangs for ever:
--
INSERT INTO [EMAIL PROTECTED]
SELECT * FROM FW.FWLOT_PN2M WHERE FW.FWLOT_PN2M.fromid =
(select
Ashoke - Sympathy, but no firm answers here. I have seen this type of
behavior before. Someone mentioned that the underlying problem is that the
Oracle optimizer doesn't have enough information to make an intelligent
decision in some database link situations. Sometimes I've given up in
Ashoke,
Can you try using an in-line view like this:
INSERT INTO [EMAIL PROTECTED]
SELECT * FROM FW.FWLOT_PN2M,(
select fw.fwlot.sysid sysid from fw.fwlot where fw.fwlot.appid =
'205956')
WHERE FW.FWLOT_PN2M.fromid = sysid;
Havn't tried this, but it is worth a shot.
good luck!
Tom
How about this ...
INSERT INTO [EMAIL PROTECTED]
SELECT a.*
FROM FW.FWLOT_PN2M a, fw.fwlot b
WHERE a.fromid = b.sysid
AND b.appid = '205956';
HTH
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at
Tom,
With this I get the following errors
INSERT INTO [EMAIL PROTECTED]
*
ERROR at line 1:
ORA-00913: too many values
Any more suggestions.
Thanks,
Ashoke
-Original Message-
Sent: Monday, April 22, 2002 12:31 PM
To: Multiple recipients of list ORACLE-L
Hi Raj,
I tried this and still it hangs.
Thanks,
Ashoke
-Original Message-
Sent: Monday, April 22, 2002 12:31 PM
To: Multiple recipients of list ORACLE-L
How about this ...
INSERT INTO [EMAIL PROTECTED]
SELECT a.*
FROM FW.FWLOT_PN2M a, fw.fwlot b
WHERE a.fromid = b.sysid
How many rows does it return ... ??
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but
It is supposed to return 15 rows.
Thanks,
Ashoke
-Original Message-
Sent: Monday, April 22, 2002 2:34 PM
To: Multiple recipients of list ORACLE-L
How many rows does it return ... ??
Raj
__
Rajendra Jamadagni MIS, ESPN
Ashoke,
sorry, try this:
INSERT INTO [EMAIL PROTECTED]
SELECT FW.FWLOT_PN2M.* FROM FW.FWLOT_PN2M,(
select fw.fwlot.sysid sysid from fw.fwlot where fw.fwlot.appid =
'205956')
WHERE FW.FWLOT_PN2M.fromid = sysid;
Tom Mercadante
Oracle Certified Professional
-Original Message-
If you've got a sql statement that expects more than one row back across a
database link it is very likely to issue a ' select column,column,etc...
from table_name' statement across the link resolve things locally via a
temporary table, which is not indexed of course.
Dick Goulet
12 matches
Mail list logo