在2个oracle表之间复制数据 [英] copy data between 2 oracle tables

问题描述

大家好，

我正在尝试将数据从一个表复制到oracle中的另一个表，两个表都位于2个不同的oracle数据库中
我不允许直接从第二个数据库访问第一个表，反之亦然
我将第一张表中的数据放入数据集中，然后将第二行中的数据逐行插入
有28000条记录，整个表上传需要6分钟，这对我来说是不允许的时间
我该如何减少此时间.
目标表没有任何索引.
由于我无法直接从目标表访问源表，因此我无法使用简单的过程，即从源表中进行选择以获取值
我需要将数据集发送到过程，但我不知道该怎么做
有人可以告诉我该怎么做吗?

Hi All,

I m trying to copy data from one table to other table in oracle both tables are in 2 different oracle database
I m not allowed to access first table directly from second database and viceversa
I m taking data from first table into dataset and then inserting row by row into second table
There are 28000 records and it takes 6 minutes to upload entire table this much time is not allowed for me
How can i minimize this time.
Destination table dont have any index.
Since i cant access source table directly from destination table i cant use simple procedure ie select from sourcetable for taking the values
I need to send dataset to procedure and i dont know how to do so
Can someone tell me how to do so?

推荐答案

请不要重新发布包含2个答案的问题.
上一个问题 [将行从一个表复制到另一个表(INSERT INTO ... select ...) [ ^ ]
在一个数据库的表之间复制数据 [将数据从一个表传输到另一个表 [ ^ ]
Oracle/关于将数据从一个数据库表复制到另一数据库表 [ ^ ]
如何在不使用插入命令和游标的情况下将数据从一个表插入到另一个表 [

Please don''t repost your question which has 2 answers.
Your Previous question[^]

Copying Rows from One Table to Another (INSERT INTO ... select ...)[^]
Copying Data between Tables on One Database[^]
Transferring Data from One Table to Another[^]
Oracle/regarding copy data from one database table to another database table[^]
how to insert data from one table to another table without insert command and cursors[^]

使用oracle OracleBulkCopy [

Use oracle ODAC[^] and OracleBulkCopy[^] - if this doesn''t do the trick, you''re out of luck. If those 28000 doesn''t contain a lot of blobs, you should be able to create something that does the job in well under a minute, maybe in less than 10 seconds.

Best regards
Espen Harlinn

这篇关于在2个oracle表之间复制数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！