CODEWITHSUNDEEP
databaseoracle-database
Ankita
Ankita

Reputation: 9

Load data from one oracle database table to another oracle database table

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.

Upvotes: 1

Views: 2775

Answers (2)

DCookie
DCookie

Reputation: 43533

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.

Upvotes: 1

Chris
Chris

Reputation: 352

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.

Upvotes: 0

Related Questions