1

I want to load data from one database table to another database table. For example there exists table 'tbl' in db1 and db2 databases, and I want to copy all data from 'tbl' of 'db1' to 'tbl' of 'db2' in oracle. Any help would be appreciated.

Improve this question
1
  • 1
    do you really mean different databases, or do you do mean different schema on the same database? Commented Apr 18, 2011 at 8:55

2 Answers 2

Reset to default
1

I would make use of either exp/imp or expdp/impdp (10g+) for this.

The older exp/imp command is slower, but has the advantage that the export file is created and read from the client system. The expdp/impdp command is much faster, but the file is created on and read from the server where the databases live. So, if you have your databases on different servers, you'll need to copy the export files around. Also, it requires an Oracle Directory to be set up by the DBA.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

In order to do this , you will need to create a database link between the two schemas. Here is a link to a tutorial that may help.

Improve this answer

1 Comment

Thanks for the above link, but following the steps that the link gives I am able to create a database link but while trying to access the link for suppose retrieving data error comes for databse link name stating "could not resolve service name"

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.