RE: batch interactive import

From: <babu.nagarajan_at_mail.iflexsolutions.com>
Date: Wed, 19 Jul 2000 20:44:37 +0530
Message-Id: <10563.112419@fatcity.com>

i use the following approach. spool all the table names in a file. edit = the
file and add lines which correspond to the interactive export. like = first
line is buffer
second id file name, etc. u can get the exact seq by running a dummy = export
interactiveyl.
then i issue exp username/pwd < the_file

this similates a interactive export and it works nicely for > 1000 = tables...

Babu Nagarajan
Citibank, Mumbai
#653-5042

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

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

> -----Original Message-----
> From: StevenHaas_at_ebico.com [SMTP:StevenHaas_at_ebico.com]
> Sent: Wednesday, July 19, 2000 7:48 PM
> 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 =
Received on Wed Jul 19 2000 - 10:14:37 CDT