Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2003
    Posts
    13

    Unanswered: 8.1.6 import hangs when try to import to an Oracle 9iR2 9.2.0.1.0

    Hi people:
    I am trying to import into NT Oracle 9i 9.2.0.1.0 server a dump file created from another NT. When I perform the import, specifying the FROM USER TOUSER parameters, the import kicks off happily but stalls at :

    Import: Release 8.1.6.0.0 - Production on Thu Jun 26 15:54:30 2003

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

    Password:

    Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.1.0 - Production

    Export file created by EXPORT:V08.01.06 via direct path
    import done in WE8ISO8859P1 character set and UTF8 NCHAR character set
    export server uses WE8ISO8859P1 NCHAR character set (possible ncharset conversion)......

    TOAD tells me that the current statement is:

    ALTER SESSION SET EVENTS '22825 TRACE NAME CONTEXT FOREVER, LEVEL 1'

    and it has been for about 3.5 hours.

    Is there a way to see, what the import is attempting to accomplish? What should I be looking for? I see no blocks nor any significant events in v$waitstat, no active session and no resource activities on the system.

    Thanks,
    Papik

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    from your message it sounds that you are trying to import into 9i using 8.1.6 imp utility.

    try importing using 9i imp utitily

  3. #3
    Join Date
    Apr 2003
    Posts
    13
    thanks osy, I did it, but it shows the same messages , so I don't understand how one can import an old export to a newer database version ? I think this is often a common backups/recovery procedure,
    any ideas ?
    Thanks a lot

  4. #4
    Join Date
    Nov 2002
    Posts
    833
    Originally posted by Papik
    thanks osy, I did it, but it shows the same messages , so I don't understand how one can import an old export to a newer database version ? I think this is often a common backups/recovery procedure,
    any ideas ?
    Thanks a lot
    first: you can take an older versions dump and import into a newer version althougth I'm not quite sure if it works on versions older 7.3 ..
    second:
    guesses only:
    is the alter session command really been issued from imp util?
    are either TOAD and instance mgr showing the same cmd?

    did you check the dump for corruption?
    what happens if you reduce the dump to one table only and give it a try?

Posting Permissions

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