Import from named pipe problem

From: Jared Hecker <jhecker_at_iago.nac.net>
Date: Thu, 27 May 1999 14:44:54 GMT
Message-ID: <GTc33.130$m4.831@nntp1>

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 ~

####################

What happens is I get the error

####################

[V01]: cat impcompsplit.log

Connected to: Oracle7 Server Release 7.3.4.0.1 - Production With the distributed and parallel query options PL/SQL Release 2.3.4.0.0 - Production

IMP-00037: Character set marker unknown
IMP-00021: operating system error - error code (dec 2, hex 0x2)
IMP-00000: Import terminated unsuccessfully            

#######################3

FYI, IMP-00037 is

00037, 00000, "Character set marker unknown"
// *Cause: export file is corrupted.
// *Action:

#######################

When I set imp to a 'show=y', I see the beginning of the dump file appear in plain english, then a bunch of screen garbage, as if imp was trying to work on a file before it was uncompressed. I'm thinking it's timing (I can't use a ''wait' command or imp would never fire).

Any suggestions would be appreciated.

If it is convenient, e-mail will reach me faster.

TIA - Regards,
jh
--

Jared Hecker	| HWA Inc. - Oracle architecture and Administration
jared_at_hwai.com	|  ** serving NYC and New Jersey **

Received on Thu May 27 1999 - 09:44:54 CDT