RE: Urgent -- pipe import ???

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Mon, 13 Aug 2001 09:06:39 -0700
Message-ID: <F001.00368C92.20010813084629@fatcity.com>

When you say you are not archiving what do you mean exactly? If you shut off auto archiving that does not shut off archiving. We had that problem. The log gets full and auto archiving does not run to clean out the archive log so the system hangs.

Ron Smith

-----Original Message-----
Sent: Monday, August 13, 2001 10: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: 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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Smith, Ron L.
INET: rlsmith_at_kmg.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------