RE: batch interactive import

Thanks Mitchell, but...

My export is over 2g compresseed and would take much too long to do it = that
way, unless I can't find figure out the other approach.

steve

mitchell.baldwin_at_bt.com on 07/19/2000 10:36:16

To: Steven P. Haas/Waterside/EBICO_at_ROYAL-HQ, nleduc_at_mediane-info.fr cc: oracledba_at_quickdoc.co.uk, oracle-l_at_fatcity.com Subject: RE: batch interactive import

=

Hi
if you know the tables, you could write a script to load the tables fro= m a
file

Create a flatfile of your tables and rem out the tables you don't want = with
a #.

Then

for $TABLE in `cat TABLELIST | grep -v #`; do

imp user/pass_at_SID tables=3D${TABLE} rows=3Dy etc etc

done

excuse any syntax errors !!!

You'll run the imp command for every table but it will get you there eventually !!!

You could also expand the script to build a list of 10 tables at a time=

then
load them

The possibilities are endless !!!

HTH Mitch

> -----Original Message-----
> From: StevenHaas_at_ebico.com [SMTP:StevenHaas_at_ebico.com]
> Sent: 19 July 2000 15:18
> To: LEDUC Nicole
> Cc: oracledba_at_quickdoc.co.uk; oracle-l_at_fatcity.com
> Subject: RE: batch interactive import
>
>
> 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 impor=
t
> 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.co=
m>,
> 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 metho=
d :
>
> % 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 pip=
e
>
> This will split the export into several files called 'xaa', 'xab', '=
xac'
> 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=
 for
> > the
> > import or export?
> >
> > TIA, again...
> >
> >
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.co=
m
> (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=

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