| 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: Import Question
Fred,
You guessed correctly. It goes through the entire export file looking to import what you asked. This is why it is better to create several export files (one for each schema).
I would guess that you could run several imports at the same time (each one reading the same export file) if this would help you.
Tom
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Fred Smith
Sent: Thursday, August 18, 2005 9:47 AM
To: oracle-l_at_freelists.org
Subject: Import Question
Hello,
I'm going schema by schema by schema importing data from an export
file.
Version: 9.2.0.3
OS: Solaris 5.8
The export file is approx ~ 14 GB.
I'm finding that even when I import the schemas (fromuser = x, touser
=x)
that only own a few packages etc., the import takes forever.
It just sits there with "Importing X's objects into X" for 20-30
minutes,
and then finally comes back with , import terminated successfully
without
warnings.
So my question is, is it simply taking so long just because it has to
search
through the entire export.dmp file?? Is there anyway to tell what it is
doing?
Thank you.
-Fred S.
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 18 2005 - 08:52:40 CDT
 |
 |