Oracle: Can IMP/EXP go to stdin/stdout?

Question

I'm scripting some data transfer routines and incorporating exp and imp into the workflow. Both of these have a FILE= parameter to specify the data file.

Is there a way to specify stdin and stdout? I would love to do something like this:

exp ... | ssh foo imp ...

Right now I'm halfway tempted to work around this with mkfifo, but that seems a bit on the clunky side.

Answer 1

Not quite stdout/stdin but it is possible to export to and import from unix pipes. Could this technique fit into your workflow? Find out more.

Incidentally, Oracle's Data Pump does not work with unix pipes.