Attached are a couple of export import scripts I received earlier from a
member of the user group.
Hope they help.
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: [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).
import.sh
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists. If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.
This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru. If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.
export.sh
