Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: batch interactive import

RE: batch interactive import

From: <babu.nagarajan_at_mail.iflexsolutions.com>
Date: Wed, 19 Jul 2000 20:47:05 +0530
Message-Id: <10563.112422@fatcity.com>


hi=20

i guess i got it worng in my prev post. i was thingking of export

grin

Babu Nagarajan
Citibank, Mumbai
#653-5042

          _\\|//_
         (' O-O ')

----ooO-(_)-Ooo----

> -----Original Message-----
> From: Vergara, Michael (TEM) [SMTP:mvergara_at_guidant.com]
> Sent: Wednesday, July 19, 2000 8:00 PM
> To: 'StevenHaas_at_ebico.com'; LEDUC Nicole
> Cc: oracledba_at_quickdoc.co.uk; oracle-l_at_fatcity.com
> Subject: RE: batch interactive import

>=20

> Easy. Simply do two imports with two different parfiles.
>=20

> ---
> =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

> Michael P. Vergara | I do it for the stories I can tell
> Guidant Corporation | - John Sebastian
> Oracle DBA |
>=20 >=20
> > -----Original Message-----
> > From: StevenHaas_at_ebico.com [SMTP:StevenHaas_at_ebico.com]
> > Sent: Wednesday, July 19, 2000 7:18 AM
> > To: LEDUC Nicole
> > Cc: oracledba_at_quickdoc.co.uk; oracle-l_at_fatcity.com
> > Subject: RE: batch interactive import
> >=20
> >=20
> > The problem is not that the export file is too big, it is that =
there is
> a
> > size limitation on the parfile.
> > I have 125 tables on the export and want to import 120 tables.
> > The parfile will hold usually 75 "tables=3D" statements at best.
> > The shell script I saw would provide answers to the interactive =
import
> > including all required table names and the "." to finish the list =
of
> > tables.
> >=20
> > Anyone?
> >=20
> > TIA...
> >=20
> > Steve Haas
> > DBA Consultant
> > at Royal & SunAlliance
> > Farmington, CT USA
> >=20
> >=20
> >=20
> >=20
> >=20
> > LEDUC Nicole <nleduc_at_mediane-info.fr> on 07/19/2000 09:53:21
> >=20
> > To: oracledba_at_quickdoc.co.uk, oracle-l_at_fatcity.com
> > cc: "'Paul.Baumgartel_at_bmgdirect.com'" =
<Paul.Baumgartel_at_bmgdirect.com>,
> > Steven P. Haas/Waterside/EBICO_at_ROYAL-HQ
> > Subject: RE: batch interactive import
> >=20
> >=20
> >=20
> > Rachel *is* a goddess, and would you believe, I tell this for free =
!!!
> >=20
> > So - about the technical question :
> > Steve, I have this - can it help ?
> > -----------------------------------------------
> > If your Compressed file is greater than 2 Giga you can use this =
method :
> >=20
> > % mknod /tmp/exp_pipe p # Make the pipe
> > % cd /fs_with_25gig_freespace # Make sure disk has space
> > % split -b2047m < /tmp/exp_pipe & # Split input to 2Gb =
chunks
> > % exp user/passwd file=3D/tmp/exp_pipe full=3Dy # Export to the =
pipe
> >=20
> > This will split the export into several files called 'xaa', 'xab',
> 'xac'
> > all of size 2047Mb. These can be fed back into import thus:
> >=20
> > % mknod /tmp/imp_pipe p # Make the pipe
> > % cd /fs_with_25gig_freespace
> > % cat xaa xab xac > /tmp/imp_pipe & # Put files into the =
pipe
> > % imp user/passwd file=3D/tmp/imp_pipe # And import
> > -----------------------------------------------
> >=20
> > HTH,
> > Nicole
> >=20
> > > -----Message d'origine-----
> > > De: StevenHaas_at_ebico.com [SMTP:StevenHaas_at_ebico.com]
> > > Date: mercredi 19 juillet 2000 15:35
> > > =C0: oracledba_at_quickdoc.co.uk; oracle-l_at_fatcity.com
> > > Objet: RE: batch interactive import
> > >
> > > Back to the original question...
> > >
> > > Has anyone seen this approach to the parameter file size =
limitation
> for
> > > the
> > > import or export?
> > >
> > > TIA, again...
> > >
> > >
> >=20
> > --------
> > If you're bored, then visit the list's website: =
http://www.lazydba.com
> > (updated daily)
> > to unsubscribe, send a blank email to
> oracledba-unsubscribe_at_quickdoc.co.uk
> > to subscribe send a blank email to =
oracledba-subscribe_at_quickdoc.co.uk
> >=20
> >=20
> >=20
> >=20
> >=20
> >=20
> >=20
> > --------
> > If you're bored, then visit the list's website: =
http://www.lazydba.com
> > (updated daily)
> > to unsubscribe, send a blank email to
> oracledba-unsubscribe_at_quickdoc.co.uk
> > to subscribe send a blank email to =
oracledba-subscribe_at_quickdoc.co.uk
>=20

> --------
> If you're bored, then visit the list's website: =
http://www.lazydba.com
> (updated daily)
> to unsubscribe, send a blank email to =
Received on Wed Jul 19 2000 - 10:17:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US