CODEWITHSUNDEEP
javasqlperformanceoracle-database
Ivan Voroshilin
Ivan Voroshilin

Reputation: 5409

How to copy huge amount of data from one Oracle database to another with good performance

I need to copy about 50 millions of rows with joins among 3 4 tables from one Oracle db to another into a single table. This is a repeating process happening from time to time. I copy only active data (meaning that there's some outdated archived data that not needed any more). We havea special java service which does this procedure via JDBC which is too slow for our needs.

Upvotes: 1

Views: 1926

Answers (2)

Aditya Kakirde
Aditya Kakirde

Reputation: 5225

You can use DataPump utility available in Oracle 10g onwards. It gives you the capability to use direct path export. To know more, here is the link -

http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_export.htm

Upvotes: 0

Rahul Tripathi
Rahul Tripathi

Reputation: 172378

You can use the Transportable Modules

The fundamental functionality of a Transportable Module is to copy a group of related database objects from one database to another using the fastest possible mechanisms.

Upvotes: 1

Related Questions