The speed depends on many factors:
1. Hardware: type and architecture of the machine, number of
processors, SGA size
2. Database version and configuration
3. Degree of parallelism
4. Where are you storing the export file? Rotational disks, SSD,
another DB (db_link)
5. Other arguments (EXCLUDE=TABLE_STATISTICS, compression)
My advice would be to do dry runs. Tests are the best way. If you are
looking for a consultant, send me a private email and we can negotiate
the price.
Regards
On 2/17/20 1:29 PM, Ahmed Fikri wrote:
Hi all,
Without knowing all db settings it is not easy to respond this question, but could someone tell me how much time approximativelly needed to export 4 TB db using datapump?
A college told me that 200 GB / hours is possible. One should adjust some parameters, excluding statistics, parallel etc.
(Sure the physical infrastructure should help )
Second: is using dblink will be faster? The servers are in the same location.
Regards