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
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
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
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
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
> #
>
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
>
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
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
; 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
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
>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
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
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
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
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
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
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
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]
->
18 matches
Mail list logo