Re: Q:export on tape / import from tape
From: Carlos Netto <Carlos.Netto_at_ibase.org.br>
Date: Fri, 14 Oct 94 16:33:00 -0300
Message-ID: <2aa.544.846%mpcbbs_at_ibase.org.br>
| Carlos Augusto Leite Netto | Voice : +55.192.51.1153 |
| Software Design Informatica | Fax : +55.192.54.6518 |
| Oracle VAR | e-mail : carlos.netto%mpcbbs_at_ibase.org.br |
| Software Development & DBA | FidoNet: Carlos Netto [4:801/31] |
User Name: Carlos Netto - ( %mpcbbs_at_ibase.org.br ) This message was processed by RAuucp from Merlin Systems Inc.
Received on Fri Oct 14 1994 - 20:33:00 CET
Date: Fri, 14 Oct 94 16:33:00 -0300
Message-ID: <2aa.544.846%mpcbbs_at_ibase.org.br>
On 14 Oct 94 02:32pm, Christian Mondrup wrote to ALL:
CM> Newsgroup: comp.databases.oracle CM> Organization: News Server at UNI-C, Danish Computing Centre for CM> Research and Education.
CM> marc_at_carto1.csl.sni.be wrote:
CM> : Hello all,
CM> : Does anybody know, if it is possible to perform a export (exp) of a CM> full : database directly on tape using either Oracle V6 or V7?
CM> : Our customer has not enough disk space to do the export first on disk.
CM> : Is it possible? If it is possible, how can I do it? We will use CM> DAT-tapes.
CM> : Any suggestions?
CM> rm -f named_pipe_name CM> mknod named_pipe_name p CM> mt rewind CM> dd if=expdate.dmp of=/dev/rmt0h bs=${BLK_SIZE} & CM> exp userid=system/${ORA_PWD} file=named_pipe_name constraints=Y CM> grants=Y full=Y inctype=complete
I did it before without using named pipes. I did:
exp userid=system/${ORA_PWD} file=/dev/rmtXXX constraints=Y ...
bye,
----->>>>>>>>>>>> Don't reply. Reply will not work! <<<<<<<<<<<<<<----
| Carlos Augusto Leite Netto | Voice : +55.192.51.1153 |
| Software Design Informatica | Fax : +55.192.54.6518 |
| Oracle VAR | e-mail : carlos.netto%mpcbbs_at_ibase.org.br |
| Software Development & DBA | FidoNet: Carlos Netto [4:801/31] |
|---------------------------------------------------------------------------|----->>>>>>>> I'll register my Silver only after bug fixes. <<<<<<<-----
| Softex 2000 member | Brazil, Sao Paulo state, Campinas city |
=============================================================================
- Evaluation copy of Silver Xpress. Day # 112
--- via Silver Xpress V4.01P [NR]
User Name: Carlos Netto - ( %mpcbbs_at_ibase.org.br ) This message was processed by RAuucp from Merlin Systems Inc.
Received on Fri Oct 14 1994 - 20:33:00 CET