Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

optimization over db link

johnnie dJul 9 2013 — edited Jul 11 2013

If I have a distributed transaction between a source and target database, such as :-

'INSERT INTO jim@target

SELECT * FROM jim@source

MINUS

SELECT * FROM jim@source AS AT :T'

*(where T is an arbitrary timestamp)

How do I force the SELECT and MINUS operations to take place on the SOURCE database only ?

At the moment the operations seem to always take place on the target database - that is, the legs of subquery are downloaded over SQL*Net and

the MINUS performed on the target DB. This is hideously inefficient.

Is there a parameter I need to set or a hint I need to run ?

Regs

JOhnnie
This post has been answered by Jonathan Lewis on Jul 9 2013
Jump to Answer

Comments

Gbenga Ajakaye

Check this other thread with similar error and some suggested solution from @Jeff Smith Sqldev Pm-Oracle.

Sql Developer 4.1.2 on Windows 7 64 bit doesn't start

Kvark

Already, do not help, that is why i create that topic, as see in many places people start asking that question... so I am not alone who have this issue.

thatJeffSmith-Oracle

the jars got corrupted or missing. delete everything, unzip the files again, and what archive software are you using to get the files out of the ZIP?

Kvark
Answer

Manage to run it! I can't explain that, but once I move sqldeveloper folder to the root of C:\ drive - its finally start fine!

Seems its a bug in it to find a required libraries if its saved somewhere else and not in C:\ drive

Marked as Answer by Kvark · Sep 27 2020
1 person found this helpful
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 8 2013
Added on Jul 9 2013
#general-database-discussions
7 comments
5,654 views