Import from Oracle 8i client hangs when Server is Oracle 10g Release 2
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

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

  1. #1
    Join Date
    Jul 2000
    Location
    Pune, India
    Posts
    80

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

    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

  2. #2
    Join Date
    Jul 2000
    Location
    Pune, India
    Posts
    80

    WaitEvent info

    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

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Import using a lower version client to a higher version server?

  4. #4
    Join Date
    Jul 2000
    Location
    Pune, India
    Posts
    80
    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

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  6. #6
    Join Date
    Jul 2000
    Location
    Pune, India
    Posts
    80
    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

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width