minus query using dblink [message #676169] |
Sat, 18 May 2019 23:31 |
sivakumar121
Messages: 29 Registered: April 2009
|
Junior Member |
|
|
Hi
I am executing the below query in Oracle and it is running for ever, because of DBLink and also tables has 50 million rows with good number of columns.
Since I am using the dblinks, obviously the query performance will go down and it is running for ever.
I am not having access to create a table in this environment and do minus.
Any thoughts how I can execute this query and see the results?
select * from abc@dblink
minus
select * from abc
Thank you
|
|
|
|
|
|
Re: minus query using dblink [message #676200 is a reply to message #676176] |
Mon, 20 May 2019 11:50 |
Bill B
Messages: 1971 Registered: December 2004
|
Senior Member |
|
|
To do what you want, you need to pull the entire table over the database link and then do the minus against the local temp table. If the initial table is big, it will take a while to pull it over into your temp tablespace
|
|
|