Import from Oracle 8i client hangs when Server is Oracle 10g Release 2

[shailesh]

Hello,

RDBMS Version: 10.2.0.1.0
Operating System and Version: Windows 2000 SP 4

Yesterday we have upgraded our database server from Oracle 10g Release 1 to Release 2 and started facing problem. Many of our clients has Oracle 8i installed and when they use import (Export works) utility with Oracle 10g Release database they are facing hanging issues. Oracle 8i client and its tools like Export/Import have worked well with 10g release 1.

Can anyone please guide us to know how to avoid this bug? Is there any workaround to this issue. For reference Export and import command parameters are given below.

EXP UserName/Password@DB File=D:\FileName.DMP Log=D:\FileName.log TABLES=TableName Compress=N

IMP UserName/Password@DB File=D:\FileName.DMP Log=D:\FileName.log TABLES=TableName ignore=y analyze=N

For more info, following details can be seen when import is executed. It halts on importing table...
---------------------------------------------------------------------------------
Import: Release 8.1.6.0.0 - Production on Mon Oct 24 19:11:56 2005

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Password:

Connected to: Oracle Database 10g Release 10.2.0.1.0 - Production

Export file created by EXPORT:V08.01.06 via conventional path
import done in WE8ISO8859P1 character set and UTF8 NCHAR character set
import server uses WE8MSWIN1252 character set (possible charset conversion)
. importing SYSADM's objects into SYSADM
. . importing table "TEMPMY" 2 rows imported

-------------------------------------------------------------------------------------
and following statement is last executed by import session.

INSERT /*+NESTED_TABLE_SET_REFS+*/INTO "TEMPMY"
("NO", "NAME"
)
VALUES (:1, :2
)


Thanks & Regards,

Shailesh

[shailesh]

Hello,

In v$Session_Wait following info was seen for Import session which hangs...

Event: SQL*Net more data from client
Wait_Class: Network
Seconds_IN_Wait: 1900

Please let us know if this gives some clue to solve this issue.

Thanks & Regards,

Shailesh

[pando]

Import using a lower version client to a higher version server?

[shailesh]

Hi Pando,

Test case is as follows...

1) Create Table on database which is 10g Release 2.
2) Use Export of Oracle 8i (Or even 10g Release 1) client
3) Drop Table
4) Use import of Oracle 8i (Or even 10g Release 1) client

On step 4 it hangs.

Regards,

Shailesh

[jmodic]

Of course id doesn't work. In step 4) you need to use imp from 10gRel2, you can't use imp utility that is an earlier release as the database.

[shailesh]

Hello jmodic,

I think there is some confusion. If I create dump of 10g (Use export of 10g) and then try to use 8i import this is not allowed.

But if I create dump using export of 8i client and later tried to use import of same client it is allowed. In this case Server version can be 8i, 9i or 10g release 1.

We have observed problem with only 10g release 2. In short I would like to confirm whether by upgrading to Oracle 10g Release 2 on database server do we have to install same release on few hundreds clients? This is not practical.

Thanks & Regards,

Shailesh

[davey23uk]

use can't use 8i imp on a higher release version, plain and simple if it has ever worked for you then you have been very lucky you MUST use the version of imp that comes with the database you are importing into