Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> import from Oracle 9 to 10 hanging
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-lReceived on Wed Jun 27 2007 - 14:07:51 CDT
![]() |
![]() |