loading 20 million rows in Oracle
Posted on 2011-03-03
A batch process needs to load 20 million rows from a database table on server 1 , to a database table on server 2. Both databses are running on Oracle 10.1.0.5 .
The database column names, definitions and attributes on source and target tables are identical. Other than data pump, do we have any other tools/options available within Oacle to do this?