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