We often need to copy fairly large databases from one server to another. The current method uses
expdp on the source, and then
impdp on the destination. This gets pretty horrible because:
- It takes up a lot of space to store the intermediary files.
- It takes a lot more time than necessary because the writing and the reading happen in sequence rather than in parallel.
Is there a way to arrange things so that the
expdp are piped directly into
impdp? For example:
expdp / parfile=export.par | ssh remote impdp parfile=import.par
What should I put into these hypothetical
If not straight
expdp write to and
impdp -- read from -- TCP-socket(s)? I could have those plumbed with