Re: Using `export` to write to tape

Hi John,

you may want to try this:

to export:

mknod /tmp/fifo
compress < /tmp/fifo|dd of=/dev/rmt0 ibs=512b obs=64k conv=sync& exp scott/tiger file=/tmp/fifo tables=<your_table>

to import:

uncompress < /dev/rmt0 > /tmp/fifo&
imp scott/tiger file=/tmp/fifo tables=<your_table>

you also can use imp or exp in the interactive version.

Have a look into FAQ.

Best regards,

Toni

In article <3dq5bi$mef_at_turtle.mrj.com>, "John P. Lybrand" <jlybrand_at_mrj.com> wrote:

> We want save the results of an `export` command to tape. I know that we can
>
> `export` data to a file and then `tar` the file to tape. However, the result
>
> of the `export` is a 1.6 GB file, and we do not have that much scratch disk
>
> space. We tried piping the results of `export` to `tar` but `tar` expects to
>
> see a list of files and not the data. The result is that `tar` tries to find
>
> files with names corresponding to each line of data.

+--------------------------------------------------------------------+
| Anton Dischner, DBA and system-programmer    Phone: +49 89 70953202|
| Institut fuer Klinische Chemie               Fax  : +49 89 70958888|
| Klinikum Grosshadern                         Home : +49 89 6254060 |
| Ludwig Maximilians Universitaet Muenchen     Handy: +49 172 8388880|
| 81366 Muenchen                                                     |
| Marchioninistr. 15                                                 |
| Germany                          Mail: dischner_at_med.uni-muenchen.de|
+--------------------------------------------------------------------+