Import Question

From: Fred Smith <fred_fred_1_at_hotmail.com>
Date: Thu, 18 Aug 2005 09:46:47 -0400
Message-ID: <BAY107-F14E67D0E29C2352AA431EDFEB20@phx.gbl>

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/

--

http://www.freelists.org/webpage/oracle-l Received on Thu Aug 18 2005 - 08:48:51 CDT