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