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 stdout
of expdp
are piped directly into stdin
of impdp
? For example:
expdp / parfile=export.par | ssh remote impdp parfile=import.par
What should I put into these hypothetical export.par
and import.par
respectively?
If not straight stdout
into stdin
, can expdp
write to and impdp
-- read from -- TCP-socket(s)? I could have those plumbed with netcat
...