| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: export to tape!!/Import from tape
Yes, you can import any table from that export if your export dmp have it.
you can use following syntax
imp userid=abc/abc file=/dev/tape tables=(a,b,z) buffer=40960000 fromuser= abc touser= xyz commit=y
Regards
Rafiq
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Date: Tue, 30 Apr 2002 03:24:59 -0800
Thank you so much mike!! I find it the same from asktom web site!! But If I want to restore different tables from the same export,should I able to do that??
>From: Hately Mike <Mike.Hately_at_churchill.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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. Export/import will then prompt
>for the next tape when required.
>
>
>i.e.
>
>exp username/password file=/dev/rmt0 volsize=100M <other options>
>
>imp username/password file=/dev/rmt0 volsize=100M <other options>
>
>
>regards,
>Mike Hately
>
> > ----------
> > From: Raghu Kota[SMTP:raghukota_at_hotmail.com]
> > Reply To: ORACLE-L_at_fatcity.com
> > 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/support/worldwide.aspx
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Raghu Kota
> > INET: raghukota_at_hotmail.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rahul
> INET: rahul_at_ratelindo.co.id
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
>
>
>____________________________________________________________________________
>________________________
>
>This email and any attached to it are confidential and intended only for
>the
>individual or
>entity to which it is addressed. If you are not the intended recipient,
>please let us know
>by telephoning or emailing the sender. You should also delete the email
>and
>any attachment
>from your systems and should not copy the email or any attachment or
>disclose their content
>to any other person or entity. The views expressed here are not
>necessarily
>those of
>Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you.
>Churchill Insurance Group plc. Company Registration Number - 2280426.
>England.
>Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
>1DP.
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Hately Mike
> INET: Mike.Hately_at_churchill.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
Raghu Kota
OCP DBA.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: raghukota_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). MOHAMMAD RAFIQ _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: rafiq9857_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Apr 30 2002 - 15:08:46 CDT
 |
 |