| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Urgent -- pipe import ???
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
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: leslie_y_lu_at_yahoo.com 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: ListGuru_at_fatcity.com (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: shermanej_at_eccic.com 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: ListGuru_at_fatcity.com (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).Received on Mon Aug 13 2001 - 12:42:30 CDT
 |
 |