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 SQLmessagefromclient event ?
I see one opened cursor ALTER SESSION SET EVENTS '28657 TRACE NAME CONTEXT FOREVER, LEVEL 1'