Re: Q:export on tape / import from tape

marc_at_carto1.csl.sni.be wrote:

: Hello all,

: Does anybody know, if it is possible to perform a export (exp) of a full : database directly on tape using either Oracle V6 or V7?  

: Our customer has not enough disk space to do the export first on disk.

: Is it possible? If it is possible, how can I do it? We will use DAT-tapes.

: Any suggestions?

rm -f named_pipe_name
mknod named_pipe_name p
mt rewind
dd if=expdate.dmp of=/dev/rmt0h bs=${BLK_SIZE} & exp userid=system/${ORA_PWD} file=named_pipe_name constraints=Y grants=Y full=Y inctype=complete

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


+      Christian Mondrup                                                      +

+      UNI-C Aarhus, Danish Computing Centre for Research and Education.      +

+      Olof Palmes Alle 38, DK 8200 Aarhus N.                                 +

+                                                                             +

+      Phone:   +45 86 78 44 44                                               +

+      Telefax: +45 86 78 44 55                                               +

+      E-Mail:  Christian.Mondrup_at_uni-c.dk                                    +

+                                                                             +

+      Opinions expressed are mine and does not reflect those of my employer. + 


+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++