RE: batch interactive import

From: <StevenHaas_at_ebico.com>
Date: Wed, 19 Jul 2000 10:17:31 -0400
Message-Id: <10563.112412@fatcity.com>

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.

Anyone?

TIA... Steve Haas
DBA Consultant
at Royal & SunAlliance
Farmington, CT USA

LEDUC Nicole <nleduc_at_mediane-info.fr> on 07/19/2000 09:53:21

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

Rachel *is* a goddess, and would you believe, I tell this for free !!!

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 = :

 % 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

This will split the export into several files called 'xaa', 'xab', 'xa= c'
all of size 2047Mb. These can be fed back into import thus:

 % 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
-----------------------------------------------

HTH,
Nicole

> -----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 f=
or
> the
> import or export?

> TIA, again...

>
>

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 Received on Wed Jul 19 2000 - 09:17:31 CDT