Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Import from named pipe problem

Re: Import from named pipe problem

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 27 May 1999 21:00:11 +0100
Message-ID: <927835571.23700.0.nnrp-11.9e984b29@news.demon.co.uk>


How about

    cat xa[a-f] | uncompress -c > /dbadmin/export/compress_pipe &     imp system/$PASS fromuser=username touser=username file=/dbadmin/export/compress_pipe rows=n indexfile=y log=imp_from_split.log

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Jared Hecker wrote in message ...
>Hi, all -
>
>We the old 'compressed export greater than 2GB' file size problem.
>Currently I have a script in place to split the export. I have a script
>that will split and compress an export just fine, but I cannot get the
>timing down on the import script. Here it is, can anyone suggest where
>I'm going wrong?
>
>######################B
>#! /bin/ksh
># import compressed/split files
>export PASS=password
>rm /dbadmin/export/compress_pipe;
>mknod /dbadmin/export/compress_pipe p;
>cat xa[a-f] > /dbadmin/export/compress_pipe &
>sleep 5
>uncompress -c < /dbadmin/export/compress_pipe &
>sleep 60
>imp system/$PASS fromuser=username touser=username
>file=/dbadmin/export/compress_pipe rows=n indexfile=y
log=imp_from_split.log
>~
>####################
Received on Thu May 27 1999 - 15:00:11 CDT

Original text of this message

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