OraFAQ Forum: SQL & PL/SQL » minus query using dblink

Home » SQL & PL/SQL » SQL & PL/SQL » minus query using dblink (Oracle 12)

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

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

Report message to a moderator

[Message index]

		minus query using dblink By: sivakumar121 on Sat, 18 May 2019 23:31
		Re: minus query using dblink By: John Watson on Sun, 19 May 2019 01:30
		Re: minus query using dblink By: sivakumar121 on Sun, 19 May 2019 03:31
		Re: minus query using dblink By: John Watson on Sun, 19 May 2019 03:46
		Re: minus query using dblink By: Bill B on Mon, 20 May 2019 11:50

Previous Topic:	Loop after fetch on generic SYS_REFCURSOR
Next Topic:	Sql query taking long time to execut

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 04:53:37 CDT 2024