copy data between 2 oracle tables

Question

1.00/5 (2 votes)

See more:

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?

Posted 14-Jul-11 0:15am

Member 8081020

Updated 14-Jul-11 0:17am

Ramalinga Koushik

v2

Add a Solution

Comments

Rhys Gravell 14-Jul-11 6:18am

Please do not repost, have a look at the responses when you asked this yesterday

2 solutions

Solution 1

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[^]

Posted 16-Jul-11 17:23pm

thatraja

Updated 16-Jul-11 17:30pm

v3

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Espen Harlinn · Accepted Answer · 2011-07-17T11:07:00

Solution 2

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

Posted 17-Jul-11 11:07am

Espen Harlinn

Comments

thatraja 17-Jul-11 20:50pm

5! for the 2nd link

Espen Harlinn 18-Jul-11 5:57am

Thank you, thatraja!