Will it work without volsize parameter? I am producing one more par file for
Pawan's reference
userid=system/password
full=y
log=/u100/app/oracle/local/dba/fullexp/log/filename.log
file=/dev/tape --Ask your Unix admin for configured tape device
#file=/dev/rmt/0m
#volsize=16384M
volsize=0 --As
Parfile export.par:
*
file=/dev/rmt0
buffer=10485760
full=yes
statistics=none
log=/tmp/export.log
*
exp system/change_on_install parfile=export.par
On 2002.08.16 01:08 Pawan D
Hi List,
How can I take export backup directly to tape. What i need to specify
for file Parameter ?
Regards
Pawan Dalmia
Extn -5259
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Pawan Dalmia
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
TED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: export to tape!!
>Date: Tue, 30 Apr 2002 02:28:27 -0800
>
>Raghu,
>
>You can just specify the tape device as the target file.
>One important difference is the optional volsize parameter which
Raghu,
I'm not quite sure what you want to do but you should be able to use the
tape(s) in exactly the same way that you would use a disk file.
It's important to remember though that for multi-volume exports you should
start the import with the first tape in the drive, whichever tape the table
you
t;[EMAIL PROTECTED]>
>Subject: RE: export to tape!!
>Date: Tue, 30 Apr 2002 02:28:27 -0800
>
>Raghu,
>
>You can just specify the tape device as the target file.
>One important difference is the optional volsize parameter which allows you
>to specify the capacity of the tape drive.
bject: export to tape!!
>
>
>
>
> Hi Friends,
>
> I need to export some 40 tables on to tape, my system is AIX415 with
> oracle7.3, some body could give steps.
>
>
> Thanks
> Raghu.
>
>
> _
$ cp dumpfile /dev/rmt0
> --
> From: Raghu Kota[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Monday, April 29, 2002 11:48 PM
> To: Multiple recipients of list ORACLE-L
> Subject: export to tape!!
>
>
>
>
>
Hi Friends,
I need to export some 40 tables on to tape, my system is AIX415 with
oracle7.3, some body could give steps.
Thanks
Raghu.
_
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/supp