Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Select from dblink

669768Feb 24 2012 — edited Feb 28 2012
Database: 11g
I have written a dynamic sql for
insert into local_table(col1, col2..) select col1, col2....from remote_table@dblink
But this is running forever.

My DBA suggested me to create a temp table as select from remote_table and insert into local_table from temp_table, like this.

create temp_table as select col1, col2.. from remote_table@dblink;
insert into local_table(col1, col2..) select col1, col2....from temp table;
Both are dynamic sqls.

The DBA suggested method is running very fast than my original method.

Does anybody know why the direct insert from dblink is running very slow, compared to the create table as select from dblink ?

Thanks in Advance.
Karbi

Comments

CloudDB
Hi,

Is it true that Database and client version should be same becuase someone has mentioned in this fourm about compatability;
YES

Regards
Hitgon
Helios-GunesEROL
Hi;

Please see:
Master Note For Oracle Database Client Installation [ID 1157463.1]
Client / Server / Interoperability Support Between Different Oracle Versions [ID 207303.1]

Regard
Helios
806917
Not true. The client version and DB version do not have to match. I still use sqlplusw.exe 10.2.0.5 on my PC and connect to both 10g and 11g databases w no problems.
Mohammed Ali A. Syed
Hi,
Is it true that Database and client version should be same becuase someone has mentioned in this fourm about compatability;
Not true. The Database and client version need not be the same but it should be supported as per document

Client / Server / Interoperability Support Between Different Oracle Versions [ID 207303.1] (Which you refered above).
"Metalink 207303.1 is the client/server interoperability matrix. If by 11g you mean 11.2 and by 10g you mean 10.1, the 11.2 client will not work with a 10.1 database. "
Here in the document it says not supported. This means if you get any issue Oracle is not going to investigate or provide a solution for you in the above case.

If the client is 11.2 and the database is 10.2, it should be at least 10.2.0.2. If the client is 11.1, the database should be 10.1.0.5 or 10.2.0.2 or higher.
Yes

Thanks
806917
One more comment - the client is incredibly stable. In my 17 years in the Oracle space, I have never logged an SR for a client issue. In general, if your client is within the last couple of major releases, you should not have any problems. Good luck!
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 27 2012
Added on Feb 24 2012
13 comments
12,025 views