Re: Export Split Script (FAO LISA)

2003-11-03 Thread Pete Finnigan
Hi Not sure what the original question was BUT the script offered splits exports so you may be interested in a tool Kurt van Meerbeeck and Kugendran Naidoo wrote called Ora*PePi availbale on sourceforge - the description from there reads: Ora*PePi is a superset of the Oracle export/import tools

RE: Export Split Script (FAO LISA)

2003-10-30 Thread Rachel Carmichael
mkfifo wrkpipe > umask 000 > # > # start the reader from the import pipe > # > imp "/" file=wrkpipe full=y commit=y buffer=4096000 LOG=$LOGFILE & > # > # create the import stream coming from the pipes > # > cat $FILENAME1 $FILENAME2 $FILENAME3 | uncompress

RE: Export Split Script (FAO LISA)

2003-10-30 Thread Robertson Lee - lerobe
eate the import stream coming from the pipes # cat $FILENAME1 $FILENAME2 $FILENAME3 | uncompress | dd of=wrkpipe # # clean up the import pipe # rm wrkpipe >From: "Armstead, Michael A" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORAC

RE: Export Split Script

2001-05-17 Thread Thater, William
On Wed, 16 May 2001,Rachel Carmichael scribbled on the wall in glitter crayon: ->de nada -- just trying to beat my fan club (thanks Ruth and Bill :) ) to ->the punch. Hi, I'm Bill and I'm a Goddess Groupie.;-) -> ->Now. in 8i (not sure which flavor) you can have export do the split as ->pa

Re: Export Split Script

2001-05-17 Thread Ruth Gramolini
000 > # > # start the reader from the import pipe > # > imp "/" file=wrkpipe full=y commit=y buffer=4096000 LOG=$LOGFILE & > # > # create the import stream coming from the pipes > # > cat $FILENAME1 $FILENAME2 $FILENAME3 | uncompress | dd of=wrkpipe > # >

Re: Export Split Script - reply from NT-Land

2001-05-16 Thread Paul Drake
Rachel Carmichael wrote: > > de nada -- just trying to beat my fan club (thanks Ruth and Bill :) ) to > the punch. > > Now. in 8i (not sure which flavor) you can have export do the split as > part of the export. I don't think it compresses it but it will at least > break the files down >

RE: Export Split Script

2001-05-16 Thread Rachel Carmichael
el A" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Export Split Script >Date: Wed, 16 May 2001 14:05:29 -0800 > >Thanks, Rachel. You're a sweetheart. > >Michael Arms

RE: Export Split Script

2001-05-16 Thread Armstead, Michael A
t; To: Multiple recipients of list ORACLE-L > Subject: RE: Export Split Script > > there is a note out on Metalink on how to do this. You can also break the > export into separate files in later versions of Oracle8i. or you can run > the > following script (modified to suit

Re: Export Split Script

2001-05-16 Thread Keith Shum
; Glaxo SmithKline > > > -Original Message- > > From: Rajaram [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, May 16, 2001 4:31 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Export Split Script > > > > If you are using Or

RE: Export Split Script

2001-05-16 Thread Rajaram
16, 2001 4:04 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: Export Split Script Rajaram, Please give me details on how to use mknod to split export files larger than 2 GB. We have broken our jobs into over 50 separate export jobs on the tabl

RE: Export Split Script

2001-05-16 Thread Rachel Carmichael
>From: "Armstead, Michael A" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Export Split Script >Date: Wed, 16 May 2001 13:07:24 -0800 > >Rajaram, > >Please give me details on

RE: Export Split Script

2001-05-16 Thread Armstead, Michael A
Pharmaceuticals IT Glaxo SmithKline > -Original Message- > From: Rajaram [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, May 16, 2001 4:31 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Export Split Script > > If you are using Oracle on Unix , You may want to u

RE: Export Split Script

2001-05-16 Thread Smith, Ron L.
Thanks to all who replied. By the way 'I tries' was a typo. I try. Thanks! Ron -Original Message- Sent: Wednesday, May 16, 2001 3:17 PM To: Multiple recipients of list ORACLE-L http://www.oracle.com/oramag/code/tips1998/index.html 1/16/98 > >I tries using a compressed export and th

RE: Export Split Script

2001-05-16 Thread Rajaram
If you are using Oracle on Unix , You may want to use unix pipes ( mknod). - most people use this method to manage files > 2GB. Rajaram (Now that I am at the top of a mountain - I dont know how to get down!) -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Wedne

Re: Export Split Script

2001-05-16 Thread Ruth Gramolini
On the LazyDBA website there are scripts written by Rachel Carmichael on do a compressed export into files of 2 gig and the corresponding import. If you can't find it let me know and I will try to send it to you. I can always send you the one I edited. My email address is below. Ruth B. Gramoli

Re: Export Split Script

2001-05-16 Thread Roy Ferguson
http://www.oracle.com/oramag/code/tips1998/index.html 1/16/98 > >I tries using a compressed export and the output is still over 2G. Does >anyone have the export script that splits the export files into multiple >files? > >Ron Smith >Database Administration >[EMAIL PROTECTED] >-- >Please see th

RE: Export Split Script

2001-05-16 Thread Scott . Shafer
http://www.oracle.com/oramag/code/tip01168.html Scott Shafer San Antonio, TX 210-581-6217 > -Original Message- > From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, May 16, 2001 2:57 PM > To: Multiple recipients of list ORACLE-L > Subject: Export Split Script > > I tr

Re: Export Split Script

2001-05-16 Thread Thater, William
On Wed, 16 May 2001,Smith, Ron L. scribbled on the wall in glitter crayon: ->I tries using a compressed export and the output is still over 2G. Does ->anyone have the export script that splits the export files into multiple ->files? -> ->Ron Smith ->Database Administration ->[EMAIL PROTECTED] ->