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

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

"Grabowy, Chris" <cgrabowy_at_fcg.com> on 07/19/2000 09:17:56

To: "'oracledba_at_lazydba.com'" <oracledba_at_lazydba.com> cc: (bcc: Steven P. Haas/Waterside/EBICO) Subject: RE: batch interactive import

Rachel's rate schedule is as follows...

Mentioning her book $1.00
Mentioning how useful her book is $5.00 Mentioning how wonderful she is $10.00 Mentioning that she is a goddess Priceless

-----Original Message-----
From: Paul.Baumgartel_at_bmgdirect.com
[mailto:Paul.Baumgartel_at_bmgdirect.com]
Sent: Tuesday, July 18, 2000 2:59 PM
To: oracledba_at_quickdoc.co.uk
Subject: RE: batch interactive import

Ruth, I don't think this is what Steven needs; those scripts (how much does Rachel pay you to promote them, anyway? ;-) ) don't address the parameter file size limitation.

--
Paul Baumgartel
Consultant to BMG Direct Marketing, Inc.
212 930-4509    paul.baumgartel_at_bmgdirect.com



> -----Original Message-----

> From: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us]

> Sent: Tuesday, July 18, 2000 2:38 PM

> To: oracledba_at_quickdoc.co.uk; oracle-l_at_fatcity.com;

> StevenHaas_at_ebico.com

> Subject: Re: batch interactive import

>

>

> Go to the LazyDBA website and looks under scripts.  There is a set of

> scripts written by Rachel Carmichael  to do compressed exports and

> uncompress them during import.  They use the OS compress function.

>

> HTH,

> Ruth

> ----- Original Message -----

> From: <StevenHaas_at_ebico.com>

> To: <oracledba_at_quickdoc.co.uk>; <oracle-l_at_fatcity.com>

> Sent: Tuesday, July 18, 2000 2:34 PM

> Subject: batch interactive import

>

>

> > Good afternoon Listers,

> >

> > env't:    HP-UX 11.0,  Oracle 8.1.5 (64 bit)

> >

> > I remember seeing on this list, some time back, a shell

> script that can be

> > used to import a list of tables from a (compressed) schema

> export when the

> > list of tables is too big for the import parm file size

> limitation.  If

> > memory serves it answers the interactive import questions

> in a batch mode.

> >

> > Does anyone remember it or has it and is willing to share.

> >

> > TIA,

> >

> > Steve Haas

> > DBA Consultant

> > at Royal & SunAlliance

> > Farmington, CT

> >

> >

> >

> > --------

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

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