0 Replies Latest reply: Jan 23, 2012 5:21 AM by Pavel RSS

    Import 8.1.7

    Pavel
      Hello!

      I am using oracle 8.1.7 import in ORACLE-multiversion environment WinXP (9.2, 8.1.7) , _8.1.7 DB installed as last product_
      total 2Gb RAM , SGA =1453M
      During full import DB hang , waiting SQL*message from client
      I'm trying to import every table separately(with buffer=6000000 and recordlength=65535 ), and the situation doesn't change.
      Task manager show higth value of VM Size (oracle.exe-process, more as SGA.
      My question :
      - sould I reinstall DB's , beginning 8'th version (oldest version) ;
      - why import hang with SQL message from client event ?
      I see one opened cursor ALTER SESSION SET EVENTS '28657 TRACE NAME CONTEXT FOREVER, LEVEL 1'


      Thank You for Help!
      Paul

      Edited by: 909612 on 23.01.2012 3:18

      Edited by: 909612 on 23.01.2012 3:18

      Edited by: 909612 on 23.01.2012 3:20