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

I process some data transfer procedures and turn expand impinto the workflow. Both parameters have a parameter FILE=for specifying a data file.

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

exp ... | ssh foo imp ...

I am currently halfway tempted to work with this with mkfifo, but it seems a bit like the clumsy side.

+3
source share
1 answer

Not really stdout / stdin, but you can export and import from unix pipes. Can this technique fit into your workflow? More details ...

By the way, Oracle Data Pump does not work with Unix channels.

+5
source

Source: https://habr.com/ru/post/1732173/


All Articles