- Datapump script is used when you have few tables/schemas to be replicated and the data volume is low.
- Any of the option from 2, 3 and 4 can be used when you have many schemas to be replicated and the data volume is huge.
- Transportable Tablespace is a wise choice over datapump for heterogeneous environment with the high data volume if you are using Enterprise Edition.
|