data copy using sql loader or data pump or cntrolfile
Posted on 2011-02-21
we are copying massive data from different tables(around 1 million rows in that tables we need only few columns) using sql query which is having 5-6 tables(with 15 columns) data with some where conditions.
both source database and dest db are oracle databases, so can you please suggest which method is better for
this data migration and please give the steps to do the following