Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Oracle / Oracle Server / January 2008

Tip: Looking for answers? Try searching our database.

Oracle 10g hanging when reading reading tables from a dmp file.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Adam Sandler - 30 Jan 2008 16:52 GMT
Hello,

I'm using Oracle 10.2.0.3.0 and I'm trying to import a 9i dump file.
I know this file is good but on this particular server.

With the HTML based OEM, I'm selecting the Maintenance tab, Import
from Export Files.  From the combobox, select "Prior to 10g", point to
the dump file location, and selecting the Tables radio button for the
import type.

The next page which pops up, with the text, "Import Processing: Read
Import File".  The page instructs the import file is being read and it
may take several minutes to complete.

I never get past this page.  I've actually let it run overnight and I
never get to the next page.

There is nothing in any of the adump, bdump, cdump, ddump, etc., log
files which indicates a failure.

I've upped the SGA and PGA size and that hasn't helped either.

So here is where I'm stuck.  There is nothing in the log, I've
increased memory, I know the dmp file is good, and when I try to
import, I it hangings on reading tables.

Suggestions are greatly appreciated.

Thanks!
gbahut@ravenpack.com - 30 Jan 2008 17:40 GMT
Hi Adam,

You probably want to test this using Oracle 9i "imp" command line
utility within ORACLE 10g, this is, out of OEM environment.
You'll find documentation regarding how to use this utility at
http://download.oracle.com/docs/cd/B10501_01/server.920/a96652/ch02.htm#1005123

I have successfully imported Oracle9i schemas into Oracle 10.2.0.1
release like that.

Good luck.

Gonzalo.
Mark D Powell - 30 Jan 2008 18:56 GMT
On Jan 30, 12:40 pm, "gba...@ravenpack.com" <gba...@ravenpack.com>
wrote:
> Hi Adam,
>
[quoted text clipped - 8 lines]
>
> Gonzalo.

Yes, run the imp program yourself as Gonzalo suggested and see how
long it takes to run.  I suggest you use the log= and feedback=
parameters on the import.  If you are unfamilar with running the
utility from the command line try the imp help=y option and/or look in
the Utilities manual.

HTH -- Mark D Powell --
Adam Sandler - 31 Jan 2008 18:28 GMT
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.