data copy using sql loader or data pump or cntrolfile
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
Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!