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: <ddorr.cs_at_clearstream.com>
Date: Thu, 20 Jul 2000 10:42:14 +0200
Message-Id: <10564.112507@fatcity.com>


Shouldn't be so difficult :

run an interactive import and note the answers you provide, put them in a file,
add the names of the tables you want to import, one per line, end the file with a .

pipe this file to imp.

That is, on unix :

mknod pipe p
zcat expfile.dmp.Z > pipe &
cat parfile | imp

with parfile containing the following lines ( in my case - Oracle 7.3.4 ) :

system/manager
pipe
4096
no
no
yes
yes
no
SCOTT
EMP
BONUS
.

Let me know if you have other probs.

> ----------
> From: StevenHaas_at_ebico.com[SMTP:StevenHaas_at_ebico.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Wednesday, July 19, 2000 17:56
> To: Multiple recipients of list ORACLE-L
> Subject: 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
>
>
>
> Hi
> if you know the tables, you could write a script to load the tables from 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=${TABLE} rows=y 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=" 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=/tmp/exp_pipe full=y # Export to the pipe
> >
> > 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=/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
> > > : 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.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
> >
> >
> >
> >
> >
> >
> >
> > --------
> > 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
>
>
>
>
>
> --
> Author:
> INET: StevenHaas_at_ebico.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
Received on Thu Jul 20 2000 - 03:42:14 CDT

Original text of this message

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