RE: Import Question
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <fred_fred_1@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 18 Aug 2005 09:50:39 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Fred Smith
Sent: Thursday, August 18, 2005 9:47 AM
To: oracle-l@xxxxxxxxxxxxx
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.
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's
FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
