Leslie,
This is what works for me on Oracle 7.3.4.4 on HP-UX
(zcat /extdisk/exp1/acc_per_06300200.dmp.Z > \
/extdisk/exp1/export_pipe &); \
imp parfile=/extdisk/exp1/newpar.par
Maybe you can try this if your Sun has zcat.
I have never seen a pipe work for a while and then fail. I think
it is probably not the pipe (unless you try to run two imports through the
same pipe at the same time?).
>From what I can see your syntax appears okay (I didn't test it) and if it
was working at the start of import then it should continue working until the
import finishes. You saw correct import messages displayed before it hung?
Are you sure the export was a good one with message
"Export terminated successfully without warnings." in the log file?
Let us know how it goes.
Ed
-----Original Message-----
Sent: Monday, August 13, 2001 11:56 AM
To: Multiple recipients of list ORACLE-L
Hi all,
I sent this last Friday. Maybe not too many people
check mail on Friday, so I send it again:
For 815 on Sun5.6, I'm using pipe to import a 1G dmp.Z
file, which can be uncompressed to a 9G dmp file:
The directory I issue the following commands has 4G
available:
mknod /tmp/imp_pipe p
uncompress < arbor_minexp_20010726.dmp.Z >
/tmp/imp_pipe &
imp file=/tmp/imp_pipe parfile=imp.par
The import worked fine for a little while and then
stuck in a table with 1048 row, which is not big at
all. It stuck there for more than 8 hours until I
kill it. (The database is not archived.)
Anything could be wrong? Should I do the uncompress <
arbor_minexp_20010726.dmp.Z > /tmp/imp_pipe & in a
directory that has 9G free space??? Also I'm not
familiar with pipe, could the pipe fail?
Thanks a lot!
Leslie
__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Leslie Lu
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
* * * * * Freedom of Information Act Notice * * * * *
The information in this email is subject to the record protection mandated
by 5 United States Code 552(b)(4) and relevant judicial opinions.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sherman, Edward
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
