Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> import from Oracle 9 to 10 hanging

import from Oracle 9 to 10 hanging

From: <Andreas.Haunschmidt_at_voestalpine.com>
Date: Wed, 27 Jun 2007 21:07:51 +0200
Message-ID: <3D8E681BD642074DBD6FF7F9D612C8E5868619@2217EXLICB3.voestalpine.root.local>

I did an export from Oracle 9.2.0.7.0. with the imp utility on the Oracle 9 server. Then I tried to import the dump files into 10.2.0.1.0 with the imp utility Oracle 10 server.

The import worked for 4 of the 3 exported users, but while importing the 4th user the import session hangs on SYS.DBMS_EXPORT_EXTENSION.reset_exp_opq_typ_event;

No IO is happening but Oracle uses almost all of the CPU.

I tried the import from version 9 to 10 repeatedly on WinXP and Linux, with different export files from the Oracle 9 DB, same effect.

Has anyone experienced the same "behavior"? Has anyone got a solution?

Thanks in advance
  Andreas

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 27 2007 - 14:07:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US